| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling macros from another XL Workbook
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling macros from another XL Workbook
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. -- Regards, Tom Ogilvy "jamesa" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CALLING MACROS FROM A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
| Calling macros in diff worksheet | Excel Discussion (Misc queries) | |||
| calling macros from worksheet to another | Excel Discussion (Misc queries) | |||
| Calling macros in another workbook | Excel Worksheet Functions | |||
| Calling macros in another spreadsheet | Excel Programming | |||
Linear Mode
