Share via


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

XlLinkType

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

See Also

Concepts

Workbook Object

Workbook Object Members