View Single Post
  #5   Report Post  
Posted to microsoft.public.dotnet.framework,microsoft.public.dotnet.framework.windowsforms,microsoft.public.excel.programming,microsoft.public.officedev
Cameron Eckman Cameron Eckman is offline
external usenet poster
 
Posts: 2
Default .NET application does not release Excel

Thanks. I also found the following article:
http://support.microsoft.com/default...b;en-us;317109

I am still having problems, but it seems to do with looping through the
cells. I'll have to do
ReleaseComObject after I'm done with each cell. What a pain in the....


"Shailesh [MVP]" wrote in message
...
Try Marshall.ReleaseComObject after quit..

Thanks.

"Cameron Eckman" wrote in message
...
Let me prefix with, I've done many VB6 and ASP applications that read
from/write to Excel and have never had a problem. I'm not a beginner at
this...

I have created my first .NET Windows application that reads from Excel

2000
and writes to a tab file. I am using the code below and when stepping
through the appExcel.Quit() is executed. However, the EXCEL.EXE process
still runs and will run until I close the .NET application I've built.

This
happens in both DEBUG and RELEASE compilations.

Try
appExcel = New Excel.Application()
... coding tasks ...

Catch ex As Exception
... error tasks ...

Finally
appExcel.Quit()

Any ideas why Excel is not being released after the quit? I even tried
adding GC.Collect() to see if it helps to force the Garbage Collection

to
release appExcel.

Thanks, in advance.