Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem using Offset property
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00531541
Message ID:
00531546
Views:
9
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform