Share via


Workbook.UpdateLink Method

Excel Developer Reference

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

Syntax

expression.UpdateLink(Name, Type)

expression   A variable that represents a Workbook object.

Parameters

Name Required/Optional Data Type Description
Name Optional Variant The name of the Microsoft Excel or DDE/OLE link to be updated, as returned from the LinkSources method.
Type Optional Variant One of the constants of XlLinkType specifying the type of link.

Remarks

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.

Visual Basic for Applications
  ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

See Also