tcmill:
reference ChangeLink Method
e.g.
ActiveWorkbook.ChangeLink "C:\test\text.xls", _
"D:\test\test1.xls", xlExcelLinks
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
" wrote:
All
Is it necessary to write a script to update links in cells refering to
other workbooks
when the files are moved to a new drive letter but the folder structure
remains the same
Are the links always relative to the current file and thus there is no
need to hardcode an absolute file path to the new drive :ie
"N:\FolderA\FolderB\MyWorkbook..."
When "\FolderB\MyWorkbook.." will do
Thanking you
Tony