View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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