CHANGE.LINK

Macro Sheets Only

Equivalent to choosing the Change Source button in the Links dialog box, which appears when you choose the Links command from the Edit menu. Changes a link from one supporting workbook to another.

Syntax

CHANGE.LINK(old_text, new_text, type_of_link)
CHANGE.LINK?(old_text, new_text, type_of_link)

Old_text is the path of the link from the active dependent workbook you want to change.

New_text is the path of the link you want to change to.

Type_of_link is the number 1 or 2 specifying what type of link you want to change.

Type_of_link Link document type

1 or omitted Microsoft Excel link

2 DDE/OLE link

Remarks

The workbook whose links you want to change must be active when this function is calculated.

Related Functions

GET.LINK.INFO Returns information about a link

LINKS Returns the name of all linked documents

OPEN.LINKS Opens specified supporting workbooks

SET.UPDATE.STATUS Controls the update status of a link

UPDATE.LINK Updates a link to another workbook

List of Command-Equivalent Functions