View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Skeets Skeets is offline
external usenet poster
 
Posts: 2
Default 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