Import into excel

Ron Bromwell · Sep 25, 2003

Hi All,
I want to import a text file into excel using VB. Can
anyone give me some ideas on how this can be done. I can
create the excel file no problem. I just can't get the
import to work.

Ron

Dave Peterson · Sep 26, 2003

If you like what you get with File|Open (and the import text wizard appears),
then record a macro when you do it.

If you want more control over the import, take a look at Chip Pearson's code:

http://www.cpearson.com/excel/imptext.htm

Import into excel

Ron Bromwell

Dave Peterson