Folder of text files into excel sheet

[MX_PMAU]

Hi,

I need to import a folder of text files (thousands) into excel, so that the filename makes one column and the contents of the text file makes one column.

So, a file named 12345.txt containing the text "Here's the text in file 12345.txt" and a file named 23456.txt containing the text "And here's the text in file 23456.txt", would give me this:

	A	B
1	12345.txt	Here's the text in file 12345.txt
2	23456.txt	And here's the text in file 23456.txt

I would be very greatful if anybody could give me a pointer on how to solve this. I don't know if Excel alone can do it, or if I should start by merging all the text files to one file (how would I get the file names into the final file?), but I'm hoping I'm not the first person to have this problem ;)

Thanks,

Pål

[Tinbendr]

Not tested.

Please Login or Register  to view this content.

[MX_PMAU]

Thanks for your reply, much appreciated. If I can future out what to do with your code, I'll post back with the result!

[Tinbendr]

Copy the code into a standard module.

Change path as required to point to text files. While the cursor is inside the code, press F8.