Call macros from another XL file

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

jamesa

How can I call
macro1
macro2
macro3
from a file named: Trainer Overview Template.xls
to use in a file named: Schedule Template.xls

Regards,
JA
 
application.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.
 
You need to open both files: Trainer Overview Template.xls and Schedule
Template.xls

Now, You can use macro1, macro2 and macro3 in Schedule Template.xls.
 
Back
Top