Excel Won't Quit
Thanks Rex. I have managed to fix my problem. I was running the Excel 5.0
object so I changed it to the Excel 9.0 object and used the code in the
previous post and it took care of my problem.
"Rex" wrote:
Microsoft analyzed this for me and determined that the problem was caused by
the Google Desktop Search Office Addin: A COM add-in is initially loaded and
assigns the reference to Excel or one of its members to a global object, the
reference isn't released so Excel continues to be a loaded process. This is
what is happening when Google Desktop Search tool is installed. This tool
doesn't release the object reference to the document (workbook).
I uninstalled Google Desktop Search and the problem went away.
I have provided this description to Google Desktop Feedback.
"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
|