[RESOLVED] [2005] HELP closing application properly

[Rikki_UW]

I have designed an application in VB which reads information from an Excel file. When the program closes I want to close the connection to and quit excel, delete the excel file it was using, and then close the application. The reason I have put Me.Close() at the end is that before it was leaving the program in memory. Here is my code:

Private Sub AcntBalanceInfo_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
        oExcel.Quit()
        Threading.Thread.Sleep(100)
        My.Computer.FileSystem.DeleteFile("C:\Bank Balance Info.temp.xls")
        Me.Close()
    End Sub

oExcel.Quit() seems to close the connection or maybe the workbook but not the process. I can then delete the file, but my application won't close because the file is missing. The way I see it, if excel closed properly then there would be nothing to read the file and it wouldn't matter that the file is missing. Does this make sense? Why is oExcel.Quit() not closing Excel properly? Attached is the file.

Thanks,
--Rikki

[.NetNinja]

I have an application doing something similar. Have you tried forcing an end to your application to release the Excel objects:

Private Sub AcntBalanceInfo_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
        oExcel.Quit()
        Threading.Thread.Sleep(100)
        My.Computer.FileSystem.DeleteFile("C:\Bank Balance Info.temp.xls")
        Me.Close()
        END
    End Sub

The application I have, if I do not force a close, the Excel objects remain open until the app is FORCED down.

[Rikki_UW]

Thanks .NetNinja, It works when I replace Me.Close() with End.

--Rikki