>>If the FOR EACH is doing garbage collection, then that is definately a good thing! I hope I remember this if/when I convert existing apps to VFP 8. This particular app is new so this is the first FOR EACH in it.
>
>I'm guessing, but I think that's what's up. A couple of years ago I reported a bug with FOR EACH and OLE Automation with Excel (even worked a bit with Garrett on a KB article, which I can't seem to locate now). The solution, as outlined in the KB article was to issue a CLEAR ALL in order to release a dangling reference to Excel in memory. Maybe this is the result of that problem.
Hmmm, I seem to recall that I had that same problem with VFP and Excel a couple of years ago as well. I have noticed I no longer need a CLEAR ALL. I have since moved on to Office XP and the current versions of VFP as they cam along. So I do not know if the problem was corrected in Excel, VFP or both.
Mark McCasland
Midlothian, TX USA