Hyperlinks and File Links

[Guest]

Hi

I have a workbook which has links to about a dozen other workbooks.

These links need to change periodically as new versions become available.

I do this manually via Edit Links Change source. (I haven't been able to do
this using VBA as two levels of folders change and the filename has two
elements which change)

I have hyperlinks in the workbook which take me to the correct place in the
linked files.

Is there any way of matching the hyperlinks with the linked workbooks and
having them update automatically as the workbook links change?

Regards

Phil Smith

 

[Dave Peterson]

I don't think it's automatic, but this could make your life easier:

David McRitchie has some code that you can use to change the hyperlinks:

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

====
You may want to start using the =hyperlink() worksheet formula. Then you'll be
able to do simple Edit|Replaces to point at a new location.