Use the macro recorder and go through the dialog box steps, and that will
give you the code to do it automatically.

HTH,
Shockley



"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