Calling macros from another XL Workbook

  • Thread starter Thread starter jamesa
  • Start date Start date
J

jamesa

How can I call
macro1
macro2
macro3
from a XL Workbook named: Trainer Overview Template.xls
to run in a Workbook named: Schedule Template.xls

I tried this suggestion:

application.Run "Trainer Overview Template.xls!Macro1"
application.Run "Trainer Overview Template.xls!Macro2"
application.Run "Trainer Overview Template.xls!Macro3"

but it does not call the macros.
What am I not doing right.

I woud be grateful
 
pplication.Run "Trainer Overview Template.xls!Macro1"
application.Run "Trainer Overview Template.xls!Macro2"
application.Run "Trainer Overview Template.xls!Macro3"

or you can create a reference (in the vbe, Tools=>References; you should
have a unique project name for each workbook, not VBAProject) from Schedule
Template.xls to Trainer Overview Template.xls and call the macros like you
would call a local macro.
 
Back
Top