>Hello,
>I am populating a spreadsheet using a scan loop with oRange=oRange.Offset(1,0) before the endscan. However, when I release my object variables at the end of the code excel process remains in memory. What can I do??? This is driving me crazy!!!
>
>Thank you,
>
tony,
While this may not be the same, it sure sounds like the same problem as described in an MS KB article (which I can't locate at the moment). In the article, using FOR EACH oCell IN oRange...ENDFOR, left an object reference to Excel that remained after issuing the oExcel.Quit command and setting the object variable to NULL. The only solution that's been found is to issue a CLEAR ALL.
George
Ubi caritas et amor, deus ibi est