Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reporting using Excel, Excel remains open
Message
De
13/03/2003 14:07:00
Dave Crowley
Alliance Marketing Services
Jamison, Pennsylvanie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Reporting using Excel, Excel remains open
Divers
Thread ID:
00765514
Message ID:
00765514
Vues:
80
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform