Hi,

I have a macro that runs over a defined directory, creates a new summary workbook, and then copies selected data from all the excel files present (in the defined directory) into that summary workbook, it then saves the summary workbook into a defined location and closes. I am obliged to change the directory name each time I have multiple folders for data merging, and sometimes over 30 directories.

I want this macro to loop automatically over several directories contained inside one root directory and perform the same operation detailed above. How can it be possible? I used the "scripting folder" method but it returned error when I ran the code...never got it worked!

Secondly, I want this macro to save the summary workbook with its folder name, the directory from which data is merged.

My code is here, please take a look and propose me a solution:

Please Login or Register  to view this content.
Thanks alot in advance!

Sanjeev