| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links to Local Drive Instead of Same Folder | Excel Discussion (Misc queries) | |||
| Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
| Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
| Links broken - UNC vs drive mapping | Links and Linking in Excel | |||
| Find links with code; change from G drive to C drive | Excel Programming | |||
Hybrid Mode
