| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute macro in other workbook
Hi !
I can't find for the moment the VBA code to execute the sequence : - open a workbook - execute a macro stored in it Thank you for your help Best regards Sylvain caillet |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
execute macro in other workbook
Hi Sylvain,
Try: Application.Run "MyBook.xls!MyMacro" If MyBook is not in the default directory, include the full path. This will open MyFile.xls (if it is not open) and run its MyMacro routine. --- Regards, Norman "Sylvain" wrote in message ... Hi ! I can't find for the moment the VBA code to execute the sequence : - open a workbook - execute a macro stored in it Thank you for your help Best regards Sylvain caillet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
execute macro in other workbook
Post cancelled. Sorry
Sylvain "Sylvain" a écrit dans le message de news: ... Hi ! I can't find for the moment the VBA code to execute the sequence : - open a workbook - execute a macro stored in it Thank you for your help Best regards Sylvain caillet |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
execute macro in other workbook
Workbooks.Open Filename:=wb_filename
Application.Run "'" & Activeworkbook.Name & "'!myMacro" If the code is added to the workbook's Workbook_Open event, it will execute automatically upon opening the workbook. -- HTH RP (remove nothere from the email address if mailing direct) "Sylvain" wrote in message ... Hi ! I can't find for the moment the VBA code to execute the sequence : - open a workbook - execute a macro stored in it Thank you for your help Best regards Sylvain caillet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto execute upon workbook retrieval | Excel Discussion (Misc queries) | |||
| Automatically execute a CTRL-ALT-F9 when I open a workbook | Excel Discussion (Misc queries) | |||
| Execute Macro | Excel Discussion (Misc queries) | |||
| How to execute macros not saved in a workbook | Excel Programming | |||
| Execute program (macro?) upon opening a workbook | Excel Programming | |||
Linear Mode
