Hi, I have agonized over the very same problem. I have found that you need to run your App in 32 bit mode, not 64. Go to Project, Properties, Compile tab. Select 'Advanced Compile Options', then set Target CPU to 'x86'. Let me know if this helps, everyone here seems to want to run macros from within Sage VBA :)

This is the Macros folder after all.... macros run in VBA.

This is the Macros folder after all.... macros run in VBA.

Macro is a misnomer. These are 32 bit COM API objects which can be hosted in VBA, but the intent is clearly an API. One can make interesting persuasive applications which consume the API, and this is what gives them their value. Granted VBA gives a happy path, but applications are limited.