I have a vb script that runs on a schedule.
It is supposed to open an excel file and refresh the links then save the file.
The problem it is that the links take a few seconds to refresh and the file closes before it is done refreshing so i end up with a bunch of #NA where the data should be
Dim xlApp, vFile
vFile = "C:\your file.xls"
Set xlApp = CreateObject("excel.application")
With xlApp.Workbooks.Open(vFile, True)
Set xlApp = Nothing