import data from multiple closed files to master file

Greetings all,

I have been searching and have not quite found an answer for my project. I want to import data from multiple closed excel files into one master file that is open.
1. All files (source and target) will reside in one folder.
2. I would like to import from all files regardless of their name if that is possible.
3. I want to import data from cells A1:C40.
4. I want to import data to one sheet that will add the subsequent data below the previous.

Your help is greatly appreciated.

Ken

Another possibility..

* Build a 2d array from the source data from each workbook in the folder and dump it at the end..


bah.. can't post the code as Succuri firewall thingo is blocking it.. see attached file...

Change strpath as needed..

majime01
ブックは閉じたままで...

Please Login or Register  to view this content.

Thank you for your post. I used the second code and it worked great...thank you so much.

Thank you for your post.

Arigato tomadachi