update all hyperlinks to another drive

[Filips Benoit]

Dear All,

Each row has in column J a hyperlink ( picture). Pictures are stored on my
computer on a folder on drive D.
If a put the workbook on another computer or change the folders location all
links are broken.
How can I restore all hyperlinks in one move (macro) .

? What is realy stored in the hyperlink-cell ????
Some hyperlinks are shown with the full path ( ex1) others with the path
starting with the workbooks' location (ex2)
ex1 = D:/Filip/articles/Fotos/foto1.jpg
ex2 = Fotos/foto1.jpg

Path workbook = D:/Filip/articles/MyWorkbook.xls
Path pictures = D:/Filip/articles/Fotos/foto1.jpg

Thanks,

Filip

 

[Guest]

Checkout the Fix Hyperlinks paragraph in :

http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyp