Importing mulitple .txt files to excel
 

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

Importing mulitple .txt files to excel
 

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" wrote in message
oups.com...
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

Importing mulitple .txt files to excel
 

On 18 Mar, 22:11, "MH" wrote:
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

"mikerobe" wrote in message

oups.com...

Hi
I have up to 100 .txtfile 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 toExcelcontains 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 inExceleach 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

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

Importing mulitple .txt files to excel
 

"mikerobe" wrote in message
oups.com...
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