Change hyperlink in all office files

[jans__]

Hello,

In our company we have a new server.
In thousands of word excel autocad powerpoint we use hyperlinks,now
the unc path is changed we have to change all hyperlinks.

Is there a tool available for this?

Thanx

Jans

 

[Ben]

This would not be difficult at all to do. Do you have a developer in-house
that you could bring this to? It shouldn't take them more than an hour or so
to code a solution for you that you can apply across all your documents.

 

[jans__]

Hi Ben,

Files can be protected, read-only or protected on other levels, how to
work around all of this.
The users points out an directory of drive to check, the tool has to
loop through all files and check if there are hyperlinks which need to
be changed
The tool should change all hyperlinks in Word, Excel,
The tool should be able to change unc-path but also there should be an
options to only change a directory
for example change //server1/mydir* into //server1/newdir*
Or change *Excelfile.xls into *Excelfile.xlt
There should also be a check if the new hyperlink file exists
There should also be a logfile where we can check wich hyperlinks from
wich file has been changed, filepath - filename - hyperlink old -
hyperlink new - fileexists yes/no - errornr
If there is someone out there who can code this tool in 1 hour or even
in 2 hours, please let me know!!!

Thanx

Jans

 

[Steve Rindsberg]

Hello,

In our company we have a new server.
In thousands of word excel autocad powerpoint we use hyperlinks,now
the unc path is changed we have to change all hyperlinks.

This might help with the PPT files

Search and Replace for Hyperlinks
http://www.pptfaq.com/FAQ00773.htm