VB Code to Update All Links in Workbook

[nofzinger]

Hi!

I have a macro that opens a bunch of workbooks and updates them. In addition, after it updates all the workbooks, it updates the links in the active workbook that refer to all the other workbooks that were just updated. The code I use to update the links in the active workbook is very cumbersome:

ActiveWorkbook.UpdateLink Name:= _
        "<file>" _
        , Type:=xlExcelLinks
    ActiveWorkbook.UpdateLink Name:= _
        "<file2>" _
        , Type:=xlExcelLinks
    ActiveWorkbook.UpdateLink Name:= _
        "<file3>" _
        , Type:=xlExcelLinks
    ActiveWorkbook.UpdateLink Name:= _
        "<file4>" _
        , Type:=xlExcelLinks

etc.

I have the same thing over and over for all the links in the workbook. I'll have to keep adding to the list everytime I link a new workbook.

Is there any simple code that just says "update all links in this workbook" without having to individually list all the actual links?

Thank you so much!

[mojo249]

Hi

Set your links to update automatically:

Edit --> Links --> Start Prompt --> Don't display the alert and update links

And in your code use

Calculate

to refresh the links.

Dion

[nofzinger]

I'm not sure this answers the question. The links do automatically update; I want to be able to update the links as the last stage of my macro. How do I use the "calculate" in my macro?