VBA Wrappers For COM Addin Functions?

Add-in Express™ Support Service
That's what is more important than anything else

VBA Wrappers For COM Addin Functions?
Can I write COM Addins that can be accessed through VBA? 
Andrew Painter




Posts: 42
 Joined: 2008-06-26
I need to provide the ability for VBA Macros in Word to call Functions and Subs in my ADX COM Addin.

I cannot add a VBA Reference to MyAddin.dll directly, since it doesn't seem to be registered as a COM component in its own right. Can I make my MyAddin.DLL register as a COM Component, add a Word VBA reference to it, and call functions directly in macros?

Thanks,

Andrew
Posted 06 Jan, 2009 14:51:43 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Andrew.

To access the add-in from the VBA project please use the Object property of the COMAddIn interface.

Application.COMAddIns.Item("<add-in progID>").Object
Posted 08 Jan, 2009 09:38:51 Top