Turn the macro recorder on

Open the file and go through the text import wizard.

Turn off the macro recorder.

Look at the recorded code. This contains the specificiations you gave.

You can add code to prompt you for a file name and feed it into the first
argument of the OPENTEXT method.

then to import the file, you just run the code.

If you need help on modifying the recorded code to accept a dynamic file
name, post back with the recorded code.

some informationon getting started with macros at David McRitchie's site
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Regards,
Tom Ogilvy

"Trey" wrote in message
oups.com...
I have a fixed length file, thats 700 characters long. Each week i
have to go in and manually import the file, and tell excel where the
fields are. The fields are the same length everytime. Is there a way
to open a new excel sheet and have it automatically import the
information? I have been looking at some scripts, but i have no idea
where to put them.