Question Locked

How can I change multiple Hyperlinks in a mapped drive?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have a shared network drive which has multiple Excel and Word documents using hyperlinks to point to a particular server name , for example \\server 1\.....\... We now need to rename our servers due to a corporate policy. Is there a way to search and replace the server name in all of these hyperlinks automatically so they all point to, for example , \\server2\...\... ?

2 replies

by seanferd

You may need to write a VBA script if you expect to do this across multiple files as a batch.

This discussion is closed to new replies.