Mega Code Archive

 

Categories / VisualBasic Script / Application

 

If you want to keep refreshing the data on a regular basis, you can make the macro run itself

Dim mdteScheduledTime As Date      Sub RefreshData()          ThisWorkbook.UpdateLink Name:="C:\YourExcel2007File.xlsx", Type:= xlExcelLinks          mdteScheduledTime = Now + TimeSerial(0, 1, 0)          Application.OnTime mdteScheduledTime, "RefreshData"      End Sub      Sub StopRefresh()          Application.OnTime mdteScheduledTime, "RefreshData",, False      End Sub