Please help: C# COM Plug-in not releasing Excel properly when embe


F

Fredrik G

Hello!

Some of you have seen this question before, but I still haven't got a
solution to my problem, and it's getting rather critical - my customers are
complaining...

My plugin implements IDTExtensibility2. If I leave the stubs (OnConnection,
OnDisconnection, etc) empty, I can open an Excel-document embedded in
Internet Explorer, and when I leave the page, such as clicking Back, Excel
will close-down. So far so good.

However, my plugin must listen to the WorkbookOpen event. I hook it up in
OnStartupComplete, like so:
applicationObject.WorkbookOpen += new
Microsoft.Office.Interop.Excel.AppEvents_WorkbookOpenEventHandler(applicationObject_WorkbookOpen);

But now, even if I leave the applicationObject_WorkbookOpen event-handler
empty, this makes Excel running like an orphaned process, when I leave the IE
page.

I am pretty aware of COM reference counting etc, but I can't figure out a
way to have an event-handler hooked up (which requires a reference to
Excel.Application) and still being able to close down Excel when the user
leaves the IE page.

Any ideas? I'm using Office XP and .NET 1.1

/Fredrik
 
Ad

Advertisements


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