I have the following as globals; oSheet is used continuously through the application and I have had the oExcel both as a global and a local (being that it's only used to open the sheet).

Private oExcel As Excel.Application
Private oSheet As Excel.Worksheet

In the function to load the spreadsheet, I have:

Set oExcel = New Excel.Application
Set oSheet = oExcel.Workbooks.Open(MyFile).Sheets.Item(1)

And finally, in the application's file closing function I have the following, which is even repeated (for test) in the form_unload:

If (Not oSheet Is Nothing) Then Set oSheet = Nothing
If (Not oExcel Is Nothing) Then
    oExcel.Workbooks.Close
    Set oExcel = Nothing
End If

When I close the application, the above runs and executes both set=nothing and the workbook close ... but, when I look at the running processes in Task Manager, I see that I still have one process of EXCEL running.

Any ideas to what I have missed?


Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

Setting a variable to nothing makes it no longer refer to anything. It does nothing to that to which it had been a reference.

In the case of class instantiation, classes are typically destroyed when the reference count becomes zero.

But it is not the same with a reference to a running application. In this case you must explicitly close the application. (BTW: your postings will look better if you use the insert code button [[u]#</u>]):

A-ha!

A terrible assumption that terminating the object would do the trick. A lesson learned for me, I see.

Note taken about the CODE option, too.

Thanks very much for the speedy response.

Regards,

Sean Anderson