How to close an Excel process by itself

[jag_chat]

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.

[tom_hotspur]

The COM object has not been released properly.
Microsoft suggest this solution using the
System.Runtime.InteropServices.Marshal.ReleaseComObject method.

Private Sub yoursub()
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()
 
'use the NAR sub to release COM object
NAR(xl)
End Sub
 
 Private Sub NAR(ByVal o As Object)
            '* Procedure: NAR
            '* Author: Microsoft
            '* Description:  This sub cleanly releases the COM Automation Object.
            '* Source: [url]http://support.microsoft.com/?kbid=317109[/url]
 
            Try
                System.Runtime.InteropServices.Marshal.ReleaseComObject(o)
            Catch
            Finally
                o = Nothing
            End Try
        End Sub

[jag_chat]

Thank you very very much...

[tom_hotspur]

I actually know something!

Wow... so thats what it feels like.