Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel automatic refresh does not refresh
Message
De
21/12/2006 10:39:56
Rasheed Al Rasheed
Riyadh Armed Forces Hospital
Riyadh, Arabie Saoudite
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel automatic refresh does not refresh
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01179576
Message ID:
01179576
Vues:
49
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
Fil
Voir

Click here to load this message in the networking platform