Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update all hyperlinks to another drive
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
update all hyperlinks to another drive
Checkout the Fix Hyperlinks paragraph in :
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyp -- Gary''s Student - gsnu2007a "Filips Benoit" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update a chart using Hyperlinks | Charts and Charting in Excel | |||
Maintaining Hyperlinks on a pen Drive | Excel Discussion (Misc queries) | |||
Update one cell with many hyperlinks | Excel Discussion (Misc queries) | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) |