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.