Thanks for the reply,

The files will be .txt files.

They will all be formatted the same way (the macro to do this has been
created).

I simply need a way of getting the text file in and outputting and
corresponding .xls. The filenames are contained in a static array and
the text files correspond to the filenames of the text files. So:

The array contains the first 4 values AAA, AAC, BAA, BUA. And the text
files AAA.txt, AAC.txt, BAA.txt, BUA.txt are in a directory.


--
carl0s66
------------------------------------------------------------------------
carl0s66's Profile: http://www.excelforum.com/member.php...o&userid=16620
View this thread: http://www.excelforum.com/showthread...hreadid=320067