[Resolved] BackgroundWorker - Destroy Excel Instance

[RobDog888]

Sup Bruce!

It not a recommended way to "clean" an Excel instance by calling the GC. Having the instance of Excel remain running after the app closes is usually from implied instanciation of Excel objects or not properly closing and destroying your Excel objects.

It looks like you are closing/destroying Excel ok but try creating an object var for each level of access you drill down the EOM.

Dim oWB As Excel.Workbook = oExcel.Workbooks.Open(CType(e.Argument, String))

'Could be re-written as ...
Dim oWBs As Excel.Workbooks = oExcel.Workbooks
Dim oWB As Excel.Workbook = oWBs.Open(CType(e.Argument, String))

Then close/destroy as you are logically are doing but loose the GC.