Excel Automatino/COM Add-In Question

M

mwieder

We're writing an Add-In the implements IDTExtensibility2 and we've also
written several functions for worksheet use and exposed it as an
Automation Add-In. I have seen articles written stating that by
implementing both, we would be able to get a handle to the Application
in the Automation Functions, but I don't see how we can. The
OnConnection method of the IDTExtensibility2 gets an application
reference, and I can pass that to an instance of my class of Functions,
but when the Functions class is called as an automation add-in, it is a
seperate copy of the class and doesn't have the handle to the
application. How can my Automation Add-In Functions class get a handle
to the application from the COM Add-In?
 

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

Top