Changes a link from one document to another.
ActiveWorkbook.ChangeLink "c:\excel\book1.xls", "c:\excel\book2.xls", xlExcelLinks
The following arguments are required:
Name (String) - The name of the Microsoft Excel or DDE/OLE link to be changed, as it was returned from the LinkSources method.
NewName (String) - The new name of the link.