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