Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel automatic refresh does not refresh
Message
From
21/12/2006 10:39:56
Rasheed Al Rasheed
Riyadh Armed Forces Hospital
Riyadh, Saudi Arabia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel automatic refresh does not refresh
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01179576
Message ID:
01179576
Views:
48
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.
Next
Reply
Map
View

Click here to load this message in the networking platform