ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Global update hyperlink address (https://www.excelbanter.com/setting-up-configuration-excel/129355-global-update-hyperlink-address.html)

j

Global update hyperlink address
 
A organizational change has prompted a request to re-assign a former folder
on the network to a different group. The current folder "owners" heavily use
hyperlinks within workbooks to other workbooks or documents. Is there a way
to globally update all hyperlinks to point to a new top level folder on the
network and retain all subfolder information?
ex: Old address M:\Engineering\...... will now be M:\ChemEngineering.....

David McRitchie

Global update hyperlink address
 
I'm not sure if this will do it but I would try this first
http://www.oaltd.co.uk/MVP/Default.htm or directly to
http://www.oaltd.co.uk/MVP/MVPPage.asp#JanKarelPieterse
look for FlexFind by Jan Karel Pieterse

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"J" wrote in message ...
A organizational change has prompted a request to re-assign a former folder
on the network to a different group. The current folder "owners" heavily use
hyperlinks within workbooks to other workbooks or documents. Is there a way
to globally update all hyperlinks to point to a new top level folder on the
network and retain all subfolder information?
ex: Old address M:\Engineering\...... will now be M:\ChemEngineering.....





All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com