.Net AddIn - Password prompt when closing Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sergei Didur - 23 Nov 2007 14:03 GMT

I am developing COM addIn for excel 2003 using C# and .Net 2.0 interop.
In the code I am sibscribing to excel events like open, activate, etc.
It looks like it causing problem with any VBA addin installed that uses same
events.

For example if you have "Lookup Wizard" addin from Microsoft - after you
click Tools\Lookup so wizard form is shown, when Excel is closed you would
get password prompt. If you don't open any VBA addin form - then not prompt
will appear.

All objects in my addin are disposed and cleared (including events), host
app domain is closed, but password prompt still appears.

Any idea what could be the problem ?

Reply to this Message

Sergei - 23 Nov 2007 22:41 GMT

It looks like there is a bug in
Microsoft.Office.Interop.Excel.AppEvents_Event class implementation - it does
not close events sink properly.

So, solution is to implement disposable event sink class based on AppEvents
interface by yourself and connect to Excel events sink using
IConnectionPoint.Advise method.

In Dispose method you would need to disconnect using
IConnectionPoint.Unadvise() method.

> I am developing COM addIn for excel 2003 using C# and .Net 2.0 interop.
> In the code I am sibscribing to excel events like open, activate, etc.
[quoted text clipped - 10 lines]
>
> Any idea what could be the problem ?

Reply to this Message

Rate this thread:

.Net AddIn - Password prompt when closing Excel

Free Magazines