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.

XlLinkType

Remark

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

Example

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

Applies to | Workbook Object