Excel object won't quit...

[coox]

Not having much luck with this one so far...

in a module:

Public xlOut As Excel.Application

In a sub:

 Set xlOut = CreateObject("Excel.Application")
 With xlOut
      .Application.DisplayAlerts = False

 etc. etc...

       .ActiveWorkbook.Close SaveChanges:=False
 End With
 xlOut.Quit
 Set xlOut = Nothing

but the damn thing won't close till I quit my app.
HHHHHHHHHHHHHHEEEEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLPPPPPPPPPPPP!

[rockies1]

I, too, have this problem...There MUST be a solution...

[coox]

Hi rockies - well I sorted my problem. Have a look at the post "Waste this dashed object". If it doesn't solve your problem then post your code (or email it to me at [email protected]) and I'll see if I can see anything wrong with it...

[HDR]

You might have more than the active workbook open. Add this line:

xlOut.Workbooks.Close


If you add it, it will look exactly like one that I have that works properly.

[rockies1]

I'll give that one a try!

Thanks!