ChangeLink command
 

try this

ActiveWorkbook.ChangeLink Name:="New Link file
Name.xls", NewName:= _
"C:\location of your File\workbook name.xls", Type:= _
xlExcelLinks

Abdul Salam

-----Original Message-----
Hello,

Does anyone know if the ChangeLink command in VBA can be
used with a Range or Cell, and if so how?

Cheers

Joe

.