Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem using Offset property
Message
 
À
17/07/2001 11:02:05
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00531541
Message ID:
00531546
Vues:
10
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform