Applies To
Workbook Object.
Description
Updates a Microsoft Excel, DDE, or OLE link (or links).
Syntax
object.UpdateLink(name, type)
object
Required. The Workbook object.
name
Required. Specifies the name of the Microsoft Excel or DDE/OLE link to update, as returned from the LinkSources method.
type
Optional. Specifies the link type. Can be either xlExcelLinks or xlOLELinks (also used for DDE links). xlExcelLinks if omitted.
Example
This example updates all links in the active workbook.
ActiveWorkbook.UpdateLink name:=ActiveWorkbook.LinkSources