Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You have to be sure you release all object variables, not only the "m_Excel"
application. Also, make sure all your variables are fully qualified. Use m_Excel.Workbooks("Whatever.xls").Worksheets("Whic hOne").Range("A1") NickHK "Avadhoot" ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to cast com object (interop) | Excel Discussion (Misc queries) | |||
-2147352573 (80020003): Unable to find the specied object | Excel Programming | |||
PivotTable Object - Unable to get the name property | Excel Programming | |||
Function unable to return Collection object | Excel Programming | |||
unable to create embedded object on a userform | Excel Programming |