Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Operating System - Microsoft
cancel
Showing results for 
Search instead for 
Did you mean: 

Help 4000+ Microsoft Office Hyperlinks broken on new server

SOLVED
Go to solution

Help 4000+ Microsoft Office Hyperlinks broken on new server

Hi all

Big problem well for me at any rate I need to be able to remove the opening path (\\TRADING_SRV)

(\\TRADING_SRV\STANDARD\ENVIRON\Environm\NOTICES\EPACT\Sec80Sec3_Noise\05.042.doc)

from all hyperlinks in Word and Excel documents on a server (thousands of links hundreds of documents) any suggestions apart from doing them all manually?

Thanks in advance John (UK)
Should of could of and would of are the mother of all ****ups
3 REPLIES
Ganesh Babu
Honored Contributor

Re: Help 4000+ Microsoft Office Hyperlinks broken on new server

u can write a VBA script to search the link and update it..

Ganesh

Re: Help 4000+ Microsoft Office Hyperlinks broken on new server

Hi Ganesh

Sorry for the delay for posting points things are a bit hectic at the moment. Do you know if the same VBA can be used for all office products (excel/word are the main ones)?

Should of could of and would of are the mother of all ****ups
Ganesh Babu
Honored Contributor
Solution

Re: Help 4000+ Microsoft Office Hyperlinks broken on new server

Hi,
The same VBA code cannot be used, but will require a minimal amount of changes to them and it will work fine..

Ganesh