WorkBook links on a new drive

  • Thread starter Thread starter tcmill
  • Start date Start date
T

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
 
tcmill:

reference ChangeLink Method

e.g.

ActiveWorkbook.ChangeLink "C:\test\text.xls", _
"D:\test\test1.xls", xlExcelLinks
 
I believe it will look in the same directory, but I don't think it will look
in the same relative directory.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get relative Path: advanced workbook linking. 1
Start a new session when a session is already opend 1
java <script> include in Master pages - src is not mapped 2
Name Increment on Open 10
Absolute vs Relative path 2
Open, print and close workbook 2
Extra Folders When Using Offline Files 1
VBA code for pasting links -- modifying RDB code for summary workbook 10

Back
Top