Macro for text import

[sunspot27]

Can someone help me out?

I need to create a VB macro to import a text file (delimited) into
excel. I need it so that when it exports, it finishes the import
wizard.

Thanks

 

[Dave Peterson]

There are so many different options that you could use, I think it would be
better to record a macro when you do it manually.

You may end up with code that works perfectly or needs minor tweaking.

If you have trouble tweaking the code, post back with your existing code and
details of how it should be changed.