Excel object won't quit...

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

in a module:

Code:

---

Public xlOut As Excel.Application

---

In a sub:

Code:

---

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!

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

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...

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.

I'll give that one a try!

Thanks!