Timer to refresh linked cells

[mummbles74]

I have cells in a summary work book that are linked to other seperate workbooks. I have recorded a macro to refresh these links as I had no Idea where to start with this one. like:

ActiveWorkbook.UpdateLink Name:= _
"S:\Maintenance\Gary Howard\IEA COW\Current Emergent Work\ANALYSER EMERG WO Current.xls" _
, Type:=xlExcelLinks

For each cell.

Is there a line of code that will refresh all these links in one go and can I set a timer on this to refresh automatically every 10mins?

Thank you in advance as always.

 

[p45cal]

would
ActiveWorkbook.RefreshAll
do it for you? (Untested)

 

[mummbles74]

No sorry this didn't seem to update any of the links that go to external sheets.

 

[p45cal]

I see in the help file for Excel vba for the Workbook.UpdateLink Method:

This example updates all links in the active workbook.
<code>ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

perhaps try that.
</code>