Turn on the macro recorder while you open the file manually and go through
the text import wizard.

After the file is opened, you turn off the macro recorder. Now you have
the code that opens the file without using the wizard, but uses the settings
you selected.

--
Regards,
Tom Ogilvy

"Mike" wrote in message
...
Hello,

I want to create a macro that would open my "mytext.txt"
file to excel worksheet without going through the prompt
that needs some formatting, like comma delimited, etc. My
text file will be look like this before I open it to excel:

2,70037,"8832322",25914,"2128123","ABC COMPANY","030628"
879,307,"100101118141",3522,"2227711","BERRY INC","030628"
.
.
.
etc.

Can anyone provide me some ideas or tips.

Thanks in advance for your help.
Mike