Calling Excel Automation Add-In in VBA

M

Matthew Wieder

We have an Automation Add-In that we developed in C# (2.0) which we are
calling from the worksheet in Excel (2003). We want to be able to call
functions in that AddIn from VBA code in teh workbook as well. If it
was a COM Add-IN, we could call
Application.COMAddIns.Item("TestAutomationAddIn.Functions").Object to
get a handle to the AddIn and make calls on it, but the
Application.AddIns Collection (where Automation AddIns are accessed)
does not expose the Object property. How can I get a handle to my
Automation AddIn?
thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REPOST: Calling Excel Automation Add-In in VBA 13
Calling Excel Automation Add-In in VBA 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
VSTO C# add in Outlook.Appointment error 0
64-bit ADODB in Excel 4
Cannot find a loaded VBA addin 3
Excel performance through COM 6

Top