ExcelComAddIn derived class

Nov 13, 2012 at 12:02 PM

Hi Govert,

I'm a relatively new user of Excel-DNA but have been very impressed with the support it provides for writing various styles of Excel AddIn and have got ComServers, RTD Servers and UDFs working successfully with relative ease.

Thanks for the fix in 0.30 release that prevents LoadComAddIn failing for an ExcelComAddIn derived class. Was wondering if there was a reason LoadComAddIn had to be called explicitly for these classes rather than being called automatically as it is for CTP and Ribbon classes?



Nov 13, 2012 at 1:57 PM

Hi David,

I can see how one might expect all ExcelComAddIn-derived classes to be loaded automatically.

The inconsistency is just due to the history of the project. Apart from the Ribbon and CTP helpers, there's not much use in having a COM Add-In, so I don't expect it to be a common case. I've since discovered one can get better notification of the shutdown using a COM add-in, but I wouldn't encourage that.

What are you using the COM add-in for?



Nov 13, 2012 at 3:03 PM

Thanks Govert,

I'm only using the COM addin for notification of Excel shutting down. I'm using a thirdparty messaging library that requires explicit cleanup otherwise it crashes Excel on the way down - nice! It's a fairly specialised case I agree.