Application VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Application
  4. Use OnTime to trigger the refresh data
Sub RunOnTime()
         Application.OnTime Date + TimeSerial(15, 0, 0), "RefreshData"
     End Sub
          
     Sub RefreshData()
         ThisWorkbook.UpdateLink Name:="C:\YourExcel2007File.xlsx", Type:=xlExcelLinks
     End Sub