Start by recording a macro while you open the text file: edit that so it
will accept a filepath selected by the user using
Application.GetOpenFilename().

Tim

"rascal" wrote in message
...
Hi:
I am trying to create a macro that when run will open a particular folder,
let you select the text file, than import it. I have gotten the marco
done
that opens the folder, however once I choose the file I am not sure how to
proceed. Right now I do it manually, when I import it I use the text
import
wizard and chose "Fixed width", start the import at line 9, move the lines
so
that they are in the proper place, then import it into excel. Once in
excel
I remove all the empty rows, which is every other row. Can I accomplish
all
this with either 1 or 2 macros. If so, any ideas on how?
Thanks a lot for any help.