Import data using macro

  • Thread starter Thread starter Elsie
  • Start date Start date
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.
 
Back
Top