Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do you stop the Excel proces from running the following code works on some boxes but not others.It seems that it is impossible to terminate the Excel process.
if(ws != null) { System.Runtime.InteropServices.Marshal.ReleaseComO bject(ws); ws = null; } if(wb != null) { for(int i = 1 ;i < wb.Sheets.Count; i++) { ((Excel.Worksheet)wb.Sheets[i]).Delete(); } System.Runtime.InteropServices.Marshal.ReleaseComO bject(wb); wb = null; } if(excelApp != null) { excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComO bject(excelApp); excelApp = null; } System.GC.Collect(); It is not possible for me to use process.kill because the web based application that this used with ddoes not issue admin rights to its users. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am also having this problem exactly as same as Hendrix4578 has mentioned below. It is really killing me. Did anybody have any idea?
thanks Ramesh "Hendrix4578" wrote: [i] How do you stop the Excel proces from running the following code works on some boxes but not others.It seems that it is impossible to terminate the Excel process. if(ws != null) { System.Runtime.InteropServices.Marshal.ReleaseComO bject(ws); ws = null; } if(wb != null) { for(int i = 1 ;i < wb.Sheets.Count; i++) { ((Excel.Worksheet)wb.Sheets).Delete(); } System.Runtime.InteropServices.Marshal.ReleaseComO bject(wb); wb = null; } if(excelApp != null) { excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComO bject(excelApp); excelApp = null; } System.GC.Collect(); It is not possible for me to use process.kill because the web based application that this used with ddoes not issue admin rights to its users. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Test Terminated Employees | Excel Discussion (Misc queries) | |||
Can password be removed on Excel WS from terminated employee? | Excel Discussion (Misc queries) | |||
Array formula returning terminated employees | Excel Worksheet Functions | |||
How do I make a process map in Excel? | Charts and Charting in Excel | |||
How to Quit an Excel process? | Excel Programming |