Workbook.ChangeLink Method
| Excel Developer Reference |
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.
.gif "Bb223228.vs_note(en-us,office.12).gif") Note |
|---|
| This example assumes at least one formula exists in the active workbook that links to another Excel source. |
| Visual Basic for Applications |
|---|
|
See Also