View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Call macros from another XL file

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.

--
Regards,
Tom Ogilvy


"jamesa" wrote in message
...
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