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 wrote:
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