UpdateLink Method [Excel 2003 VBA Language Reference]

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

expression**.UpdateLink(Name**, Type)

expression Required. An expression that returns a Workbook object.

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


XlReferenceStyle can be one of these XlReferenceStyle constants.
xlLinkTypeOLELinks (also used for DDE links)


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


This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

Applies to | Workbook Object