This worked great for me also.
I am having a problem though.
When i do correct the hyperlinks, some of them go back to the
previous way it was, or changes to some wierd format and I'm unable to use
the links at all.
Do you know what might be happening, or do i need to be more specific?

"Dave Peterson" wrote:

I'm sure David McRitchie will be pleased that it worked for you.

haslamslane wrote:

Outstanding tip - I was fretting about changing 200-400 hyperlinks in a
spreadsheet (because the server name had changed) but this script did the job
in seconds.

"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

bnbbond wrote:

I had to move an excel file that I have over 200 hyperlinks to specific files
inside the same folders. The main hyperlink is common to all of the
hyperlinks, I need to know if there is a way I can do a search and replace a
piece of the hyperlink in excel. I'm using MS Excel 2003 SP1

--

Dave Peterson


--

Dave Peterson