Replacing a Hyperlink file page name.

[iceberg]

I have set up a number of hyperlinks to videoclips in my excel
spreadsheet, but I am now changing the folder name where my videoclips
are maintained, and therefore, I wish to do a bulk change to the "File
Page Name", otherwise I will need to edit each hyperlink one by one, to
point to the new folder.

For example, I wish to change the Hyperlink "File Page Name" from :
'C/Old Folder/Video1' to 'C/New Folder/Video1'.

The problem is that "Find & Replace" only reads the "Display Text", and
doesn't actually see the "File Page Name".

There is probably an easy answer for this, but I can't find it, and
would appreciate any assistance.

Thanks, Iceberg.

 

[Dave Peterson]

David McRitchie has some code you can use at:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Look for: Fix Hyperlinks (#FixHyperlinks)

It was written for xl2k and higher.

If you use xl97, then change this line:
hyp.Address = Replace(hyp.Address, OldStr, NewStr)
to
hyp.Address = application.substitute(hyp.Address, OldStr, NewStr)

(Replace was added in xl2k.)

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