-
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.
-
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]
-
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
