Dear all,

im trying to copy a folder for a monthly reporting incl. subfolders and existing links.

I found out, that links of files that are in the same folder are automatically updated.
If you have files in different folders, those absolute links do not update though.
Sadly i "inherited" this reporting and can not change the paths, file extensions and such, as other tools of other departments link to them as well.

Let me give you a few infos first...
The folder structure looks something like this:
C:\Reporting\Reporting201303\
C:\Reporting\Reporting201303\0001\
C:\Reporting\Reporting201303\0002\
...
C:\Reporting\Reporting201303\DB Tools\
Most folders only have one file in it, some have more than one. In total its about 90 files, all in seperate subfolders.
Links between files in one folder automatically update, links between files in different folders do not update.
Right now i'm solving this problem with "find and replace", but as most reporting files have 18.000+ external links, this takes about 30 minutes per file...

Well, now the March reporting works no problem.

When copying the March folder to "Reporting201304" the links in the April files refer to the old March folder/files now.

Basically im looking for a way to put relative links in the files... e.g.:
"./" (current folder)
"../" (one level up in the path)
"../0002/REP_0002.xls" (one level up and down into subfolder "0002")
etc.

Sadly neither the forum, nor google could help me with this issue.

As i inherited this whole thing, the .xls file extension can not be changed

The (for me) ideal solution would be, to just copy the folder to a new name and all links will work fine :D

Thanks for your help and kind regards!


PrinzK