UpdateLink Method
This documentation is archived and is not being maintained.

Workbook.UpdateLink Method

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

Syntax

expression.UpdateLink(Name, Type)

expression   A variable that represents a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
NameOptionalVariantThe name of the Microsoft Excel or DDE/OLE link to be updated, as returned from the LinkSources method.
TypeOptionalVariantOne 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



Show:
© 2016 Microsoft