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).


expression.UpdateLink(Name, Type)

expression   A variable that represents a Workbook object.


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.


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.

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

© 2016 Microsoft