Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Reporting using Excel, Excel remains open
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement