Workbook.ChangeLink Method (Excel)
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 |
The link type. |
Example
This example changes a Microsoft Excel link.
Note
This example assumes at least one formula exists in the active workbook that links to another Excel source.
ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel\book2.xls", xlExcelLinks