View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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