General information
Category:
COM/DCOM and OLE Automation
Title:
Excel automatic refresh does not refresh
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only