Calling Excel 4 Macros From VBA
 

How can I call an Excel 4 macro from a VBA routine in the same workbook

Thanks,
Eloy

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