How to make an Excel Process...close by itself
-
Dim FN As String = Server.MapPath("\esmp\temp\" & Session.SessionID & ".xls") Dim xl As New Excel.Application Dim wk As Excel.Workbook = xl.Workbooks.Add() xl.Cells(2, 2) = "its ok" wk.Close(SaveChanges:=True, FileName:=FN) wk = Nothing xl.Quit() xl = Nothing ------------------------------- that was the coding I wrote in the button click event. It does work fine...but it is creating a separate process every time, the event is fired...and the process from task manager could not get deleted automatically. If I click on button 5 times....5 processes named as "EXCEL.EXE" are staying in the processes of TaskManager. So, How to make the process to close byitself after the completion of its work.
-
Dim FN As String = Server.MapPath("\esmp\temp\" & Session.SessionID & ".xls") Dim xl As New Excel.Application Dim wk As Excel.Workbook = xl.Workbooks.Add() xl.Cells(2, 2) = "its ok" wk.Close(SaveChanges:=True, FileName:=FN) wk = Nothing xl.Quit() xl = Nothing ------------------------------- that was the coding I wrote in the button click event. It does work fine...but it is creating a separate process every time, the event is fired...and the process from task manager could not get deleted automatically. If I click on button 5 times....5 processes named as "EXCEL.EXE" are staying in the processes of TaskManager. So, How to make the process to close byitself after the completion of its work.
You have to force garbage collection to clean everything up. Check out this link http://discuss.develop.com/archives/wa.exe?A2=ind0108C&L=DOTNET&D=0&m=19532&P=70662[^] or http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q266/0/88.asp&NoWebContent=1[^]