Workbook.ChangeLink Method
Changes a link from one document to another.
Syntax
expression.ChangeLink(Name, NewName, Type)
expression A variable that represents a Workbook object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Name | Required | String | The name of the Microsoft Excel or DDE/OLE link to be changed, as it was returned from the LinkSources method. |
| NewName | Required | String | The new name of the link. |
| Type | Optional | XlLinkType | The link type. |
Example
This example changes a Microsoft Excel link.
| Visual Basic for Applications |
|---|
|