Workbook.UpdateLink Method
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 |
|---|
|