Unable to release Excel COM object

A

Avadhoot

Hi,

I have to code a ASP.Net application, where the user will be able to open an
excel file on clicking a web button. I have implemented the application using
Excel PIA of Office 2k3. I have completed the code, but
the Excel.exe process is still visible in the Task Manager.

The code i use to close Excel object is given below.
// m_Excel is Excel.Application object
if(m_Excel != null)
{
m_Excel.Quit();
m_Excel = null;
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
}

The code compiles and executes properly. But after I close the application,
I can still view the Excel.exe process in the Task Manager. The process
remains in the background untill I close it manually.

I also tried using ReleaseCOMObject but was unsuccessful.

I tried the methods in the following URL, but nothing worked.
http://msdn.microsoft.com/office/pr...part2.asp#officeinteroperabilitych2_part2_rco

Does anyone know the solution to the problem.
Can anyone tell me the way to
 
N

NickHK

You have to be sure you release all object variables, not only the "m_Excel"
application.
Also, make sure all your variables are fully qualified.
Use
m_Excel.Workbooks("Whatever.xls").Worksheets("WhichOne").Range("A1")

NickHK
 

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