Excel won't completely close!

[joey o.]

Hi,

I'm having trouble completly closing Excel
I'm creating the Excel object like this:

Set appxl = CreateObject("Excel.Application")
Set xl = appxl.Application


'Then I'm killing it like this:

Set appxl = GetObject(, "EXCEL.Application")
With appxl
.ActiveWorkbook.Close savechanges:=False
.Quit
End With
Set appxl = Nothing
Set xl = Nothing

It disapears from the taskbar as if it's gone but low and behold it's still sitting as open in the task manager.
What am I doing wrong? It still closes with my application but I want it gone when I tell it to go!
Please help.

Thank You in advance.

[Nitro]

You should try something like this:

Set appxl = CreateObject("Excel.Application")
Set xl = appxl.Application

'Get rid of this line because you are creating another 'instance I believe
'Set appxl = GetObject(, "EXCEL.Application")


Your Processing Area

With appxl
.ActiveWorkbook.Close savechanges:=False
.Quit
End With

Set appxl = Nothing
Set xl = Nothing



Try this and let me know because I experienced something like this many years ago.

[Edited by Nitro on 04-18-2000 at 08:41 PM]

[joey o.]

Thanks Nitro,
That was it - I was creating another instance as well as closing excel before it could close anything else. It's all cleared up now thanks to you.
Joey o