Workbook.ChangeLink (Excel)

Changes a link from one document to another.

ChangeLink (Name, NewName, Type)

ActiveWorkbook.ChangeLink "c:\excel\book1.xls", "c:\excel\book2.xls", xlExcelLinks

Arguments

The following arguments are required:

Name (String) - The name of the Microsoft Excel or DDE/OLE link to be changed, as it was returned from the LinkSources method.

NewName (String) - The new name of the link.

The following argument is optional

Type (XlLinkType) - The link type.

Possible Values are xlLinkTypeExcelLinks - A link to a Microsoft Excel source, xlLinkTypeOLELinks - A link to an OLE source.