| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call macros from another XL file
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call macros from another XL file
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. Uzytkownik "jamesa" napisal w wiadomosci ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to call other macros | Excel Worksheet Functions | |||
| Call a batch file from an Excel Macro | Excel Discussion (Misc queries) | |||
| VBA to call file based on date | Excel Discussion (Misc queries) | |||
| Macros - call or launch from fromula | Excel Programming | |||
| Subroutine call without file reference | Excel Programming | |||
Hybrid Mode
