I create the Excel app, wb and sheet objects.
I set the wbs to Nothing.
Do the children sheets get set to nothing or do we have to set each sheet to nothing?
When in Florida, Don't Tampa with the code. I made this up.
I would try setting the Excel object to nothing and see if you still have a problem.
Patience is like bread I say.... I ran out of that yesterday.
Hey Kevin, as gencke said - we will be good if we set Excel object = nothing
The reason could be the subset objects will be purged when this excel object is closed and purged
I don't do anything specifically with sheets.
Once I've finished with my sheet data I use:
Set Excel = Nothing
... just another Tester ...
Genke, Vijaj, Alex,
most welcome. Btw was surprised when you posted this question - thinking that "was kevin's account hacked", lol.