Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reporting using Excel, Excel remains open
Message
De
13/03/2003 14:30:28
 
 
À
13/03/2003 14:21:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00765514
Message ID:
00765528
Vues:
18
'Release' will only release the variable. It won't take XL out of memory, and it really isn't needed anyway if oleexcel is local. oleexcel.quit() is the way to go as Selim pointed out.

Alan

>try:
release oleexcel
>
>hope that helps
>
>>I am hoping someone can help me.
>>
>>Using a FoxPro program to output data into an Excel sheet. The program runs
>>fine, but leaves an invisible excel open. The only way to determine whether
>>or not an excel is open is to look in the task manager (Alt + Ctrl + Del).
>>The computer completely locks up until the invisible excel in the task
>>manager has been cancelled.
>>
>>Commands used are
>>
>>oleexcel = CREATEOBJECT("Excel.application")
>>oleexcel.APPLICATION.workbooks.OPEN(&rpt_name)
>>oleexcel.APPLICATION.worksheets("Sheet1").ACTIVATE
>>
>>oleexcel.activeworkbook.SAVE
>>oleexcel.APPLICATION.workbooks(1).saved = .T.
>>oleexcel.APPLICATION.workbooks(1).CLOSE
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform