Operating System - Microsoft
1748288 Members
3501 Online
108761 Solutions
New Discussion юеВ

Re: 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 3
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