Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Windows Forms application that uses the Excel application to create
a spreadsheet, saves it and then quits the excel application - all programmatically. The problem is that the Excel.exe process remains running in the background until the windows forms application is exited. I've tried the following: //FIRST TRY: /**Do Garbage Collection as suggested as best practice at: * http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx */ excelWorkBooks = null; mainbook = null; sheet = null; someRange = null; /**Quit the application.*/ excelApplication.Quit(); excelApplication = null; /**Collect Garbage (Twice).*/ GC.Collect(); GC.WaitForPendingFinalizers(); GC.Collect(); GC.WaitForPendingFinalizers(); //SECOND TRY private void releaseCOMObject(object COMObject){ try { if(COMObject != null) while(System.Runtime.InteropServices.Marshal.Relea seComObject(COMObject)0); } finally { COMObject = null; } } //THIRD TRY: private void releaseCOMObject(object COMObject){ try { if(COMObject != null) System.Runtime.InteropServices.Marshal.ReleaseComO bject(COMObject); } finally { COMObject = null; GC.Collect(); GC.WaitForPendingFinalizers(); GC.Collect(); GC.WaitForPendingFinalizers(); } } The methods are invoked after the application is done using the COM objects. How can I close the Excel.exe process? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel window closed but process still running | Excel Programming | |||
Urgent Help needed - I need to stop a process that is running forever in Excel | Excel Discussion (Misc queries) | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
Excel process remains running | Excel Programming |