| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro of another workbook
Hello
Is it possible to open a book and make some of its macros run by code?, I just can activate the macro editor in the macro i'm interest to run but i can't make it run. My situation is like this: I have a workbook with a button that opens another book which contain a macro i need to run in order to find a value but I can't figure how to make it run without inserting the code of that macro in my project code and repeat a code that is in the workbook i just have opened. Could someone help me, please |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run a macro of another workbook
Have a look at help on run.
sub test() 'open the other file application.run "filename!macroname" end sub Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Audie G. Bencosme R." wrote in message ... Hello Is it possible to open a book and make some of its macros run by code?, I just can activate the macro editor in the macro i'm interest to run but i can't make it run. My situation is like this: I have a workbook with a button that opens another book which contain a macro i need to run in order to find a value but I can't figure how to make it run without inserting the code of that macro in my project code and repeat a code that is in the workbook i just have opened. Could someone help me, please |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run a macro of another workbook
Audie,
Application.Run "otherfile.xls!macroname" John "Audie G. Bencosme R." wrote: Hello Is it possible to open a book and make some of its macros run by code?, I just can activate the macro editor in the macro i'm interest to run but i can't make it run. My situation is like this: I have a workbook with a button that opens another book which contain a macro i need to run in order to find a value but I can't figure how to make it run without inserting the code of that macro in my project code and repeat a code that is in the workbook i just have opened. Could someone help me, please |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run a macro of another workbook
one way:
Application.Run "Workbook2.xls!MyMacro" In article , "Audie G. Bencosme R." wrote: Hello Is it possible to open a book and make some of its macros run by code?, I just can activate the macro editor in the macro i'm interest to run but i can't make it run. My situation is like this: I have a workbook with a button that opens another book which contain a macro i need to run in order to find a value but I can't figure how to make it run without inserting the code of that macro in my project code and repeat a code that is in the workbook i just have opened. Could someone help me, please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saving macro from workbook to Personal Macro Workbook | Excel Discussion (Misc queries) | |||
| Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Runing a macro in a workbook from another macro in other workbook | Excel Discussion (Misc queries) | |||
| Help:Running a macro in one excel workbook from another workbook | Setting up and Configuration of Excel | |||
Linear Mode
