Call macro in other sheet
Hi Thomas
Look at this:
Application.Run ("SlaveFile.xls!Macro1")
Regards,
Per
"Tomas Stroem" skrev i meddelelsen
...
I have a Master file containing a macro that opens a number of other
workbooks, collects data and the creates statistics from this retreived
data,
work well. Now I need to create some statistics in on of the workbooks
that I
open from my Master. In this Slave file I have the macro that I want to
run,
but only when the Master is running. How can i call the macro in the Slave
worksheet from the code in the Master macro.
Greatful for all help!
--
Tomas S
|