Workbook.UpdateLink Method (Excel)

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

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.

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
Show:
© 2014 Microsoft