 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / November 2007Password prompt when closing Excel
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 ? Microsoft help & support site have an article on this subject which may help. http://support.microsoft.com/kb/280454  SignatureJB > 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. [quoted text clipped - 10 lines] > > Any idea what could be the problem ? 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. > Microsoft help & support site have an article on this subject which may help. > http://support.microsoft.com/kb/280454 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. > It does not apply to my case. > [quoted text clipped - 8 lines] > > Microsoft help & support site have an article on this subject which may help. > > http://support.microsoft.com/kb/280454 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.