Google グループは Usenet の新規の投稿と購読のサポートを終了しました。過去のコンテンツは引き続き閲覧できます。
表示しない

HELP - VB to Excel - TIA!

閲覧: 2 回
最初の未読メッセージにスキップ

Zarius Xandor

未読、
2003/12/06 21:05:472003/12/06
To:
I am developing an application and would like to process the data,
then pass it along to a spreadsheet, I have intermediate skills, and
have the data processing part complete, and write the data to a text
file. I would like to take that text file and put it into an excel
worksheet. I would also like to take data from a text box array in a
form and pass that to the worksheet. Does any one have some sample
code on how to do this? I just need to know how to put the information
from my text files, or textboxes, into certain cells, in certain
workbooks in excel. Please respond here, or to the following email
addresses:

richer...@yahoo.com and ram...@jayenn.com

As always, I am thank ful for your cooperation and help!!!!!

Rich

Scott Simpson

未読、
2004/01/13 20:07:132004/01/13
To:
You need to go to the DATA menu and select 'get external data'. Then you
need to import the text file into a blank sheet on your spreadsheet. Once
you have it import into excel, you can then write code or use macros to copy
and paste it where you want it to go.

"Zarius Xandor" <Zarius...@yahoo.com> wrote in message
news:cf25tvc8bo5mjrbs0...@4ax.com...

新着メール 0 件