Import data using macro

[Elsie]

Hi, how do you use excel to import a text file using a macro to do the work
for you?

 

[Dave Peterson]

I start by creating a new workbook.

Then turn on the macro recorder and open that text file. (Try not to make
errors--it can make clean up troublesome.)

Then format the worksheet (headers/footers/page layout/filters,freeze panes)
exactly the way you want.

When you're done, turn off the macro recorder. Close the imported file and back
to your other workbook.

Insert a giant button from the forms toolbar on the first worksheet (with
instructions).

Then save it.

Now go into the vbe and start tweaking your code.