Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Excel 4 Macros From VBA
How can I call an Excel 4 macro from a VBA routine in the same workbook
Thanks, Eloy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Excel 4 Macros From VBA
To execute an Excel 4 macro command:
Application.ExecuteExcel4Macro the help example: MsgBox ExecuteExcel4Macro("GET.CELL(42)") Otherwise, if the macro has a name (a macro you wrote in an excel 4 macro sheet) then use Application.Run Application.Run "Macro1!XL4_Code" Here there is a cell named "XL4_Code" on the XL4 macro sheet named "Macro1". The XL4 code begins at this cell. -- Regards, Tom Ogilvy "Eloy" wrote in message ... How can I call an Excel 4 macro from a VBA routine in the same workbook Thanks, Eloy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling macros in another workbook | Excel Worksheet Functions | |||
Calling Macros From VB6 | Excel Programming | |||
Calling macros from a VB app | Excel Programming | |||
Calling Macros from a list | Excel Programming | |||
Calling Excel FUNCTION MACROS Programmatically from VB | Excel Programming |