Calling macros from another XL Workbook

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
 
T

Tom Ogilvy

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.
 

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

Call macros from another XL file 2
Stop Command Question 4
switching workbooks using variable and wilcard filename 8
Run code from another workbook 7
How to escape this error message 1
How to Run a Macro From WB1 in WB2 Against WB2 5
Removing Macro in ThisWorkbook 4
confused and confounded! 6

Top