Global update hyperlink address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J - 05 Feb 2007 23:38 GMT

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.....

Reply to this Message

David McRitchie - 07 Feb 2007 04:58 GMT

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

> 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.....

Reply to this Message