repetitive text imports

[Guest]

I'm importing many files into excel using text import wizard. I delineate
them all exactly the same but it takes time to do it. I was wandering if
there was a way to do it automatically with a macro, etc? thank you for any
help

 

[Guest]

Hi,
Go to Tools > Macro > Record New Macro...
Then go through your import wizrd routine and, when you're finished, click
the stop recording button.
Post back if you need help from there.

 

[Guest]

ok i thought that would work, and it did. thank you!