Multiple text file import including file name.

Hi All.

First post and certainly not the first problem. Thanks to google and some good coders so far (from another post on the site), I have got the following code.

Please Login or Register  to view this content.

This code imports and appends the new file at the bottom of the last one in column 2.. What I want to do is match each line with the filename of the text file being imported.

EG

File 1.txt

This
Is
Data

COL1 COL2
1.txt This
1.txt Is
1.txt Data

Any ideas?

Seems I wrote it a while back...

See if this is what you wanted

Please Login or Register  to view this content.

Originally Posted by jindon

Seems I wrote it a while back...

See if this is what you wanted

Gentlemen, Scholar and Lifesaver. Thankyou!