Excel 365 - How do find/replace a part of the hyperlink

[SandsB]

Changed servers. Find/Replace doesn't see the text I need to change. What's the trick to doing a mass change (1,000's) of hyperlinks?

 

[SandsB]

Definitely something with the %. If I change it to anything else it works fine. Even though it's surrounded by ", could it be interpreting %20 as a variable or something with meaning to VBA?

\c$\Users\MyID\OneDrive%20-%20BRT%20Services,%20Inc\Documents%20-%20BRT_RMT\MAR\CURRENT\Recent@20Update%Plus%20Pending.pdf

 

[bobsan42]

Sorry, but it looks quite messy to me and I don't think I can help further w/o hands-on your system.
It's a cloud connected folder, which is on your machine (?) but you access it through localhost (?) hidden shares and it is a relative link.
I will try to test it, but I am confused trying to grasp the idea.

 

[bobsan42]

i tested it.
i added links to onedrive through localhost, then started xlsx file through localhost., etc.
and due to security settings I got some messages from it - saying location may not be secure.
The strangest thing - I think the problem comes from here: \c$\Users\MyID\ .....
I think xl considers this as relative link, but does not send you to the root as one may expect. so it doesn't start with \\localshost.
But it adds the starting path of the xlsx file: so you end up with something like:

the %20 is no problem at all. it is totally standard and actually a must for most of the normal hyperlinks.
however, ..\..\..\..\c$ this works

the way I see it - the xlsx must be in the path of the hyperlinks, and then you can make them really relative, not starting from c$

This also should work (or with any other network address):
\\localhost\c$\Users\MyID\OneDrive%20-%20BRT%20Services,%20Inc\Documents%20-%20BRT_RMT\MAR\CURRENT\Recent@20Update%Plus%20Pending.pdf