How to run Excel macro?

[Micromegas]

There was a 6 years old discussion at AutoHotkey.com, which recommended using either

Code: Select all

oExcel := ComObjActive("Excel.Application")
try oExcel.Run("MyMacro")

or, supposedly better,

Code: Select all

oExcel := Excel_Get()
try oExcel.Run("MyMacro")

The first one doesn't elicit a response from Excel to the hotkey I assigned, and the second one fails with "Error: Call to nonexistent function." Has this changed since then, or is there anything I'm forgetting?

[Blackholyman]

excel_get() is a UDF so you need the function in your script

All try and Remove the TRY on the run Line to see the error it may give

[Micromegas]

Thank you, that showed me my VBA error, and it works now.

For future reference, I also found this related forum discussion: ComObjActive(CLSID).