Merging Data from Multiple Workbooks into 1 Workbook (Inc Subfolders)

Hi.

Wondering if anyone can help?

I am currently using the following code but I want to make it work on workbooks within subfolders as well:

Please Login or Register  to view this content.

So would work in for example

C:\Estimate Collation\Person1
C:\Estimate Collation\Person2
C:\Estimate Collation\Person3
C:\Estimate Collation\Person4

As well as just the folder C:\Estimate Collation

Is this possible?

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

We can take that main macro and turn it into a subroutine that is called by another macro. We feed in the folders to the macro and work our way deeper and deeper until all folders are processed.

Then we create a main macro to set things in motion... create a blank workbook and feed in the main folder name. That is fed to a "loop" macro that first processes that main folder, then starts detecting folders and restarting the "loop" again in each folder, deeper and deeper until all are processed.

Please Login or Register  to view this content.