Edit Hyperlinks
 

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.

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

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

"Dave Peterson" wrote:

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