Hello,
I have a big Excel file with many worksheets&hyperlinks to other documents all over my PC. After I update to Win10 the path for documents (and hyperlinks) is changed:
Old = C:\Users\nzw\AppData\Roaming\Microsoft\Excel\...
New = C:\Users\nzw\AAA\...
The "..." contains the rest of path that is unchanged.
Basically in need to change the first part of hyperlink as above and I need a macro to work for me. The change all hyperlinks manually is not an option (i have hundreds).
I look for some VBA codes but none was working for me.
Can anybody help?
Thanks in advance.
I have a big Excel file with many worksheets&hyperlinks to other documents all over my PC. After I update to Win10 the path for documents (and hyperlinks) is changed:
Old = C:\Users\nzw\AppData\Roaming\Microsoft\Excel\...
New = C:\Users\nzw\AAA\...
The "..." contains the rest of path that is unchanged.
Basically in need to change the first part of hyperlink as above and I need a macro to work for me. The change all hyperlinks manually is not an option (i have hundreds).
I look for some VBA codes but none was working for me.
Can anybody help?
Thanks in advance.
Last edited by a moderator:
