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
|