By Krainbuerger on Tuesday, 21 December 2021
Posted in Excel
Replies 1
Likes 0
Views 4.7K
Votes 0
Hello everybody,

I've just a problemm to replace several relative Hyperlinks at the same time. To replace an absolute Hyperlink like "C:\Users\MAT\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\01_95D\" into a relative one like "..\01_95D\", is no problem.
If I want to replace an existing relatvie Hyperlink like "Strama\Messprotokolle%2028.04%20Komplett\SAAL\NEU\", then nothing will be found in the Search, but the link really exists. If I'm searching only until the "%", everything is ok. If it's included, it will not be found. So it seems, that spaces can not be handled in the Hyperlink.
Has anyone a suggestion?

Thank you
Mathiew
 
Hi Krainbuerger,

Sorry I don't quite understand. Did you mean when you replace an existing relatvie Hyperlink like "Strama\Messprotokolle%2028.04%20Komplett\SAAL\NEU\" with spaces, let's say 3 spaces, nothing will happen?
And when you replace "Strama\Messprotokolle“ with 3 spaces, it worked?

Amanda
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post