Excel (orphan process)

[charles]

has anyone been able to release Excel Object from process
stack.

// my sample cleanup code
oWB.Close(null,null,null);
oXL.Workbooks.Close();
oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oRng);
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oXL);
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oSheet);
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oWB);
oSheet=null;
oWB=null;
oXL = null;
GC.Collect(); // force final cleanup!

[William Ryan]

If you close the workbook, then close the xlapp myBook.Close myExcelApp.Quit

Set oExcel to nothing instead of null
and try the GC.Collect then
"charles" <ch*************@hotmail.com> wrote in message
news:07****************************@phx.gbl...

has anyone been able to release Excel Object from process
stack.

// my sample cleanup code
oWB.Close(null,null,null);
oXL.Workbooks.Close();
oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oRng);
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oXL);
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oSheet);
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(oWB);
oSheet=null;
oWB=null;
oXL = null;
GC.Collect(); // force final cleanup!