Excel Won't Quit
Hmmm. I tried replacing XL.Quit with Application.Quit, but Excel stays up
even after the program ends.
Rex
"Inbar" wrote:
Just do Application.Quit (without the XL object) and it will quit.
"Rex" wrote:
After running this code, Excel remains:
Dim XL As Excel.Application
Set XL = CreateObject("Excel.Application")
XL.Workbooks.Open "C:\TEMP\AnyOld.XLS"
XL.Workbooks.Item(1).Close False
XL.Quit
Set XL = Nothing
Also tried .Close True and tried omitting .Close call.
What am I missing?
Rex
|