Auto Open Files and Run Macros

[amonty78]

Hi guys,

Just wondering if there is a way to automatically open a file, run a macro within the file, then save and close the file after the macro is completed.

So for example, I have a file called "Main" and 11 other files named "1", "2", "3", "4"....etc
Each numbered file draws data from the "Main" file.

So is there a way to open file "1", run a macro within that file, then save and close, then move on to file "2" and repeat all the way up to file "11" ??

Not sure if this is even possible so any feedback would be great thanks.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.