Execute a Macro from one excel Application to another Application
 

Hi All

I have two excel applications open and was wondering if you execute a macro
from one application by the other application?

Jason

Execute a Macro from one excel Application to another Application
 

From one workbook run the other by using.....

Application.Run ("yourfilename.xls!yourmacroname")


--

Regards,
Nigel




"Jason Zischke" wrote in message
...
Hi All

I have two excel applications open and was wondering if you execute a
macro
from one application by the other application?

Jason

Execute a Macro from one excel Application to another Applicat
 

Hi Nigel

Thanks for your answer but its not exactly what Im chasing besause this
requires the two workbooks to be open in the same excel window.

Jason

"Nigel" wrote:

From one workbook run the other by using.....

Application.Run ("yourfilename.xls!yourmacroname")


--

Regards,
Nigel




"Jason Zischke" wrote in message
...
Hi All

I have two excel applications open and was wondering if you execute a
macro
from one application by the other application?

Jason