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?