Macro consolidation + record filename

[dudumomo]

Hi there,

I'm looking to consolidate around 100 files having the same format (without headers) into 1.
I need to records the files names that is being imported in the last column for example, in order to keep track.

Ideally, it would be nice to run the macro from a new excel file and the macro will ask to select the folder where all the files are, for the consolidation.

I found some similar macro but never with the the file name record.

Do you have some example that I could reuse for such macro?

Thank you!

 

[Fazza]

Maybe you can work it out from 'Basic_Example_1' code at http://www.rondebruin.nl/win/s3/win008.htm

See the comment line "'Copy the file name in column A" ?

HTH

 

[dudumomo]

Thank you Fazza.

It does take the filename! Good.
However their full macro only copy paste the first line. I will have to tweak it.

Also, I've just realized that all my files are csv.

Any different macro for csv then?

Thanks

 

[Fazza]

please try google, there are many on line samples. Also (that is, also as per my earlier post) by Ron de Bruin is

http://www.rondebruin.nl/win/s3/win021.htm