View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Avadhoot Avadhoot is offline
external usenet poster
 
Posts: 2
Default Unable to release Excel COM object

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/pro...ych2_part2_rco

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