Workbook.UpdateLink (Excel)

Updates a Microsoft Excel, DDE, or OLE link (or links).

When the UpdateLink method is called without any parameters, Excel defaults to updating all worksheet links.

UpdateLink (Name, Type)

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

Arguments

The following arguments are optional

Name (String) - The name of the Microsoft Excel or DDE/OLE link to be updated, as returned from the LinkSources method.

Type (XlLinkType) - One of the constants of XlLinkType specifying the type of link.

Possible Values are xlLinkTypeExcelLinks - A link to a Microsoft Excel source, xlLinkTypeOLELinks - A link to an OLE source.