I have a MS Excel 2007 document. It has moved onto a different machine and I want to change part of the hyperlink location path on a few hundred cells. For example, current path is
I want to batch change this to:
I know I need to run a macro but anything i have tried has not changed any hyperlinks or returned an error message
Any help would be greatly appreciated.