WorkBook links on a new drive
 

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

WorkBook links on a new drive
 

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

WorkBook links on a new drive
 

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

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
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