| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling excel macro not located in that workbook.
Can I call an excel macro programmatically from another workbook in Excel 2003? For example suppose I have 2 workbooks, book1.xls and book2.xls: book1.xls module1 macro1 book2.xls module2 macro2 How would I call book2.module2.macro2 from book1.module1.macro1? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling excel macro not located in that workbook.
Hi cr113
You can use Application.run Application.Run "YourFile.xls!YourMacro" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "cr113" wrote in message ... Can I call an excel macro programmatically from another workbook in Excel 2003? For example suppose I have 2 workbooks, book1.xls and book2.xls: book1.xls module1 macro1 book2.xls module2 macro2 How would I call book2.module2.macro2 from book1.module1.macro1? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling excel macro not located in that workbook.
On Apr 1, 4:15*pm, "Ron de Bruin" wrote:
Hi cr113 You can use Application.run Application.Run "YourFile.xls!YourMacro" -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "cr113" wrote in ... Can I call an excel macro programmatically from another workbook in Excel 2003? For example suppose I have 2 workbooks, book1.xls and book2.xls: book1.xls * *module1 * * * *macro1 book2.xls * *module2 * * * *macro2 How would I call book2.module2.macro2 from book1.module1.macro1?- Hide quoted text - - Show quoted text - I had to do a workbooks.open "book2" first, but it worked. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open PDF located in excel with macro | Excel Programming | |||
| Calling a Macro from another workbook | Excel Programming | |||
| Calling up the macro dialog to list stored macros in a workbook-VB | Excel Programming | |||
| How to reference a Class Module located in an add-in or another workbook? | Excel Programming | |||
| Close current Workbook after calling macro in other | Excel Programming | |||
Linear Mode
