Workbook.ChangeLink method (Excel)
Changes a link from one document to another.
expression.ChangeLink (Name, NewName, Type)
expression A variable that represents a Workbook object.
| 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. |
This example changes a Microsoft Excel link. This example assumes that at least one formula exists in the active workbook that links to another Excel source.
VB
ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel\book2.xls", xlExcelLinks
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.