ChangeLink Method

Microsoft Excel Visual Basic

expression.ChangeLink(Name, NewName, Type)

expression    Required. An expression that returns one of the objects in the Applies To list.

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.

XlLinkType can be one of these XlLinkType constants.
xlLinkTypeExcelLinks default
xlLinkTypeOLELinks. Use for both DDE and OLE links.

Example

This example changes a Microsoft Excel link.

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