CODEWITHSUNDEEP
excelvb.netwinforms
ThisGuyJustNeedsHelp
ThisGuyJustNeedsHelp

Reputation: 115

Excel process shows back up after closing excel

I am opening an excel file from my winform using:

Dim xlsApp3 As Excel.Application
Dim xlsWB3 As Excel.Workbook
xlsApp3 = CreateObject("Excel.Application")
xlsApp3.Visible = True
xlsWB3 = xlsApp3.Workbooks.Open("C:\myfile.xlsm")

Try
    Marshal.ReleaseComObject(xlsWB3)
    Marshal.ReleaseComObject(xlsApp3)
    xlsWB3 = Nothing
    xlsApp3 = Nothing
Catch ex As Exception
    xlsWB3 = Nothing
    xlsApp3 = Nothing
Finally
    GC.Collect()
    GC.WaitForPendingFinalizers()
    GC.Collect()
    GC.WaitForPendingFinalizers()
End Try

When I look at my task manager, it closes the process, but as soon as I close the excel application window that I open, the process comes back? If I close my whole winform application, thats when the excel process closes. Is the application holding on to the process in memory?

Upvotes: 0

Views: 73

Answers (2)

djv
djv

Reputation: 15782

Don't access anything unmanaged with two dots like you did in

xlsApp3.Workbooks.Open

The Workbooks object is opened behind the scenes but .NET doesn't know about it and it can't clean it up properly.

Instead, you need to make a .NET reference to Workbooks, and the GC will clean everything up for you. Your entire code snippet can be reduced to this

Dim xlApp = New Excel.Application()
Dim xlBooks = xlApp.Workbooks
Dim xlBook = xlBooks.Open("C:\myfile.xlsm")
xlApp.Visible = True

Upvotes: 0

Dave
Dave

Reputation: 160

Add the following lines:

xlsWB3.Close(True, Type.Missing, Type.Missing)        
xlsApp3.Quit

Upvotes: 1

Related Questions