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.

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.

This example changes a Microsoft Excel link.

Note 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
Show:
© 2014 Microsoft