To start, I am a novice at VBA.

Tyring to import files that are automatic file gernated from another
application (txt type
file). I want to import the first x lines - the header of the file - in a
"Delimited" format. The rest of the file I want to import just under the
imported header in a "Fixed Width" format. The file name will continually
vary and so will the location (I already have created code to compensate for
the file name and location).

The file will vary in lenght (which I have code to compensate for multiple
worksheets).

Now while importing the "data" portion of the file, on a line by line basis,
I need to execute additional functions (lookup type information) to another
file to decode the information.

Unfortunately, with my limited knowledge of VBA, I am doing this in small
steps and hopefully put it all together in the end - not the best way but I
can always optimize once I get it to work and learn more.

Thanks