Importing mulitple .txt files to excel

[mikerobe]

Hi
I have up to 100 .txt file in a folder each containing one line of
text in a pipe delimited format. Each line of text contains the same
number of data items and once delimited to Excel contains the same
data type in each column. I would like to iterate throught each file
in the folder and be able to import each line of text to the same
sheet in Excel each line being imported to its own row. Can anyone
give me a clue as how I would go about this using VBA. Thanks all...
Mike

 

[MH]

There is a utility called TxtCollector which will append all those text
files into one, then you can import one big text file:

http://bluefive.pair.com/txtcollector.htm

MH

 

[mikerobe]

There is a utility called TxtCollector which will append all those textfilesinto one, then you can import one big text file:

http://bluefive.pair.com/txtcollector.htm

MH

Thanks for the ultra quick response, great app and doing the job
perfectly

 

[MH]

Thanks for the ultra quick response, great app and doing the job
perfectly

That app has saved me so much time over the past year. Glad you like it.

MH