Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel automatic refresh does not refresh
Versions des environnements
Hi All
I have this code in excel automation
Release All Like oEx*
Local oExcel
gcxlsLive = "C:\TMP\SHR_FND.XLS"
oExcel = Createobject("Excel.Application")
oWorkbook = Getobject(gcxlsLive)
oExcel.workbooks.Open(gcxlsLive)
oExcel.DisplayAlerts = .F.
oExcel.Quit()
Release oExcel
REST OF CODE...
The SHR_FND.XLS file imports external data from a web query.
When I excecute the code it does not update my tables with the latest data, however, If i open the excel file manualy through excel it request confirmation for automatic refresh and then I save and it works ok.
What I would like is automatic refresh without user intervension.
Any help is appreciated.
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