Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, I want to access the same instance as the automation addin. As I
mentioned, this can be done with a COM AddIn by getting Application.COMAddIns.Item("TestAutomationAddIn.Fu nctions").Object however, an automation addin is not part of the comaddins collection. However, as you point out, it IS a 'COM dll' and should be accessable from the VBA. Can someone help? thanks! John.Greenan wrote: The automation add in exists as a COM dll - right? Do you want to access the same instance of the automation addin? I don't know how to do that. If you want to access an instance then simply add a reference to the dll in your VBA project. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calling Excel Automation Add-In in VBA | Excel Programming | |||
Calling Excel Automation Add-In in VBA | Excel Programming | |||
Repost Excel Server Problem | Excel Programming | |||
RePost - Calling a Macro from a key | Excel Programming | |||
repost: Print *.tif file from excel vba | Excel Programming |