Refreshing excel links

[Mr_K]

I have an excel workbook with multiple links.

Initially I wanted to be able to refresh the links in the sequence I liked. I then created a command button with the ff code:

ActiveWorkbook.UpdateLink Name:="Link1", Type:=xlExcelLinks
ActiveWorkbook.UpdateLink Name:="Link2", Type:=xlExcelLinks

I now can refresh the links in the sequence I want the only problem I now have is that it brings up a pop up window for each link I have to refresh. I want to automate this process and without getting a pop up window to confirm the location.

Help is greatly appreciated!

 

[sykes]

Hi

Not sure if this will do the trick, as I havn't used it much, but try:

Application.DisplayAlerts = False
ActiveWorkbook.UpdateLink Name:="Link1", Type:=xlExcelLinks
ActiveWorkbook.UpdateLink Name:="Link2", Type:=xlExcelLinks
Application.DisplayAlerts = true

 

[Mr_K]

About refreshing links

Hi,

Thank you for your suggestion. Unfortunately it still presents me with the pop up windows.

Thank you again.