Execute a Macro from one excel Application to another Application

  • Thread starter Thread starter Jason Zischke
  • Start date Start date
J

Jason Zischke

Hi All

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

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

Application.Run ("yourfilename.xls!yourmacroname")
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TWO Instances of Excel One watching Other 3
open and close another app from macro 4
macros in excel application object 3
excel application object 1
Need help on VBA excel macro and API to close an external application 0
Macro execution changes filename reference for all macros 1
Is This Possible? 3
Running Macros Remotely (.tcl file) 0

Back
Top