Copy text files loop into excel

[Inactiver183192]

Hi All

I actually don't have any code I don't even know where to start. I have a series of various text files with two columns in each text and I want to be able to paste them all under each other into one spreadsheet. I was looking for some code that might be similar to the

FOR each Workbook in application.workboook

which would loop through each open text file and copy that data into excel. I was hoping to have data copied from what is opened rather than a destination as the folders change names and the names on the files aren't consistent. I'd appreciate any help on where to start and what function I should look at. Thanks!

Re

 

[Andrew Poulsom]

Start here:

http://www.rondebruin.nl/csv.htm

 

[Inactiver183192]

That code looks a bit complicated and it seems to be saving the text file as an excel file. I want to instead add the data in the text file to a excel spreadsheet I already have set up. Thanks for the link though I'll have a look through it futher.