Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problems with hyperlinks | Excel Discussion (Misc queries) | |||
How to switch to edit the cell | Excel Discussion (Misc queries) | |||
Can VBA edit hyperlink(s) address | Excel Discussion (Misc queries) | |||
up-date hyperlinks in Excel | Excel Worksheet Functions | |||
Edit Hyperlinks Globally | Excel Worksheet Functions |