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!