update all hyperlinks to another drive

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
F

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
 
Back
Top