Calling Excel 4 Macros From VBA

[Guest]

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

Thanks,
Eloy

 

[Tom Ogilvy]

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.