VBA Excel - Need Help retrieving same cells from same named files many different subfolder

[Sap-Aggie]

Hello,

I am new to VBA but hopefully someone has a moment to help . I have to build a spreadsheet that gathers cell data range from a excel file which has the same file name in many subfolders. The File name I "Performance.xlsx" and is in about 500 different subfolders under the same directory. The data needs to populate 1 spreadsheet. I have the following which works but I need help on getting it to loop through and retrieve from same file in all subfolders.

here is what I have … Thank you so very much for any help..

Please Login or Register  to view this content.

[Leith Ross]

Hello Sap-Aggie,

Welcome to the forum!

Try this version of your macro. It has been expanded to search the parent folder and all subfolders using the DIR command. This will work on all platforms even Mac. There are other methods you can use like the File System Object or Shell Application Object to do this also.

Delete your macro and then copy and paste the code below into the module.

Please Login or Register  to view this content.

[Sap-Aggie]

Thank you so much!!!! I will try it and let you know.

Again, regardless of my success I want to thank you for your valuable time and willingness to help!

[Leith Ross]

Hello Sap-Aggie,

You're welcome. That's why I am here.

[Sap-Aggie]

So greatful! It worked great! Wow do I have a long way to go when looking at your code. Again, thank you so much.

[Leith Ross]

Hello Sap-Aggie,

It is a bit complex. I will answer any questions you have. Just ask.