Macro to open Excel file, run other macros save, and close file & repeat.

Hi all,

I've build an simulation in Excel and would like to collect results based on a number of different parameters. The file is designed to run a monte carlo simulation with one set of parameters. So I would need to make a copy of the simulation file and change the parameters in that copy. There is a macro in the file that runs the simulation X number of times and saves the results in different columns. Lets call the macro RunMonteCarlo.

Is it possible to create a macro that opens the file (e.g. Simulation_1), runs 'RunMonteCarlo', saves the file and opens another file (e.g. Simulation_2) to run the 'RunMonteCarlo' macro in that file?

Thanks for the loop macro. I've tried inserting my monte carlo macro (Run_MC) in the loop macro but I keep hitting errors.

I've tried this line after the loop macro defines 'wb' as the opened workbook:

wb.Run "Run_MC"

It returns error 438: object doesnt support this poperty or method.

I've also tried:

Application.Run "Run_MC"

But then I'm getting 1004: application defined error, probably because it wants to run Run_MC in the loop file instead of in the workbook it opened.

Any suggestion on how to refer to Run_MC in the loop macro?

Figured it out:

Application.Run ("'" & myFile & "'!Run_MC")