closing excel (i know i know...)

[xxentric]

i know this is a big problem for a lot of people and there are posts everywhere... but they aren't helping lol.

below, should this complete and close and terminate excel correctly? or am i missing something...

            oExcel = CreateObject("Excel.Application")
            oBooks = oExcel.Workbooks
            oBook = oBooks.Open(Filename:="C:\Jared FC Project Desktop\fixture tracking.xls", UpdateLinks:=False, ReadOnly:=False)
            oSheet = oBook.Worksheets(1)
            oExcel.Visible = True

                oSheet = Nothing
                oBook.Close()
                oBook = Nothing
                oBooks.Close()
                oBooks = Nothing
                oExcel.Quit()
                oExcel = Nothing

[HanneSThEGreaT]

I'll still throw in ReleaseComObject here :

xlbook.Close
'...do the same as the following for range references if any, and all the excel stuff you've used...
System.Runtime.InteropServices.Marshal.ReleaseComObject(ws) 'the worksheet
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlbook) 'the workbook

xlapp.Quit()

System.Runtime.InteropServices.Marshal.ReleaseComObject(xlapp) 'the application

[MarMan]

What does it do?

[weirddemon]

What does it do?

I'm glad you asked. It so happens that MSDN has all the answers

This method is used to explicitly control the lifetime of a COM object used from managed code. You should use this method to free the underlying COM object that holds references to resources in a timely manner or when objects must be freed in a specific order.

More info in the link

Then you can look up the documentation for the .Close method and see what the differences are.

[xxentric]

well i haven't tried the code provided (im about to)

currently the excel process is still in task manager .... (yeah that crappy problem)

[xxentric]

after the code below... the process still remains in task manager

            oExcel = CreateObject("Excel.Application")
            oBooks = oExcel.Workbooks
            oBook = oBooks.Open(Filename:="C:\Jared FC Project Desktop\fixture tracking.xls", UpdateLinks:=False, ReadOnly:=False)
            oSheet = oBook.Worksheets(1)


                System.Runtime.InteropServices.Marshal.ReleaseComObject(oSheet) 'the worksheet
                oBook.Close()
                System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook) 'the workbook
                oBook = Nothing
                oExcel.Quit()
                System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel) 'the application
                oExcel = Nothing

[minitech]

You could try killing the process:

For Each p As Process In Process.GetProcessesByName("excel")
     p.Kill()
Next

Though that would close excel if the user had it running.