View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] patstix@gmail.com is offline
external usenet poster
 
Posts: 8
Default Excel Instance Hanging Around

Why does this code keep an Excel instance hanging around? I free all
the COM objects:


Sub Test()
Set oXL = CreateObject("Excel.Application")
Set WBs = oXL.Workbooks
Set Wkbk = WBs.Add
Set Wkbk = Nothing
Set WBs = Nothing
oXL.Quit
Set oXL = Nothing
End Sub

If I remove the WBs.Add line then the instance disappears as it
should; what hidden object is created there and how do I free it?