Edit Hyperlinks

[yazz22]

I have an excel sheet with around 2000 hyperlinks pointing to files on our
company's internal server. The location of the files has to be changed (new
network architecture). Is there a way of finding/replacing a part of the
hyperlink? The normal Find/Replace function does not look in the hyperlinks.
thx.

 

[Dave Peterson]

Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[yazz22]

Thanks a lot Dave (& David McRitchie), the macro worked like a charm.