How to get a reference to the Excel application inside a classimplementing IRTDServer
 

Hello,

I am developing an Excel Add-in along with an RTD server. The add-in
creates some buttons in a custom toolbar used to configure the RTD
server. They are deployed as different COM servers loaded by Excel (I
am using Visual Studio 2005 and Office 2003).

I would like to know a way to exchange variables beetween the add-in
and the RTD server. The add-in has direct access to the Excel
application through an input parameter for the
IDTExtensibility2.OnConnection method. But I don't know how the RTD
server (the class implementing IRTDServer) can get a reference to the
Excel application (the only link beetween this class and Excel is a
IRTDUpdateEvent object used to notify Excel data updates).

Do you have any ideas? Is there any straightforward way to do what I
want?

Thanks a lot.

Alex.