Hello,

I have the following problem. Any comments/suggestions would be of great help.

I have a huge collection of excel files each having a set of macros. Instead of opening each file to execute the macros within the workbook, is there any easier way to do so by the use of another master or control file. By master file, i mean i would want to create an excel file that has a small program of sorts that can then open each file, execute the macros in the file, save the changes made to the file and close it before moving to the next file.

Is there a simple way of accomplishing this without changing the macros in the individual files.

Thanks