WorkBook links on a new drive

[tcmill]

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

 

[chijanzen]

tcmill:

reference ChangeLink Method

e.g.

ActiveWorkbook.ChangeLink "C:\test\text.xls", _
"D:\test\test1.xls", xlExcelLinks

 

[Tom Ogilvy]

I believe it will look in the same directory, but I don't think it will look
in the same relative directory.