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

Ron Bromwell wrote:

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