Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
HELP - VB to Excel - TIA!
2 views
Skip to first unread message
Zarius Xandor
Dec 6, 2003, 9:05:47 PM12/6/03
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:
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
Jan 13, 2004, 8:07:13 PM1/13/04
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.
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 new messages