Password prompt when closing Excel

S

Sergei Didur

I am developint 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 ?
 
S

Sergei Didur

It does not apply to my case.

I am having problem with any VBA AddIn including the ones created by
Microsoft (unless they are not following their own recomendations).

The problem only occurs when .Net add-in and VBA add-in subscribe to the
same Excel event and VBA add-in shows any form.

It looks like a bug to me.
 
S

Sergei

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.
 

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