View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Matthew Wieder[_4_] Matthew Wieder[_4_] is offline
external usenet poster
 
Posts: 1
Default REPOST: Calling Excel Automation Add-In in VBA

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.