enable and run several macro enabled files

Dear All,

If I have a folder with around 10 excel files containing a macro, is there a way that I can select them all, enable macro, run macro and save?

Certainly I have like 15 folders with ten Excel files in each, that's why I am looking for automation.

Best wishes and thanks in advance.

Short answer is, yes. You can.

Firstly, you'll need a way to select a folder and cycle through each and every file (one at a time)
Read here on how to do it http://www.thespreadsheetguru.com/th...a-given-folder

Then you'll need to run a specific type of macro within the opened workbooks.
For that, you can use the Application.Run method
e.g. Application.Run 'Workbook A.xlsm'!Macro1