Run-time error '7': Out of memory

I am trying to run a small script that is intended to change part of the hyperlink address of all hyperlinks in an excel sheet (there are a few hundred links that are now pointing to the wrong server, i.e. the file names will be maintaned, but the server path needs to be changed). I have tried two different scripts, both produce the same error, "Run-time error '7': Out of memory". The scripts look like this:

Please Login or Register  to view this content.

Both of them error in the Replace part. Anybody got an idea?

Moderator Note:

Pls use code tags around your code next time as per forum rules.

the below should do the trick and not only update your actual link but also text displayed to show link

Please Login or Register  to view this content.

The text displayed to show the link is only the file name, so I don't want to update that. Your code didn't give any error messages, but it didn't change any links either

Update: It works on a small test-sheet I've made, but not in the big one... so probably something that makes it not recognizing the text to search for or similar... I'll investigate further

ah might be the \ i used versus the / you have
i tested the code this time and it works fine here

update : saw your update , now thats a bit strange

you can use this one and see where it stops counting and last address it updated

Please Login or Register  to view this content.

it looks for the string \oldpath\ in the hyperlink address and only when it finds it with does the replace
ctrl +mouse over still shows old link or new one ?

if you want to get details :

Please Login or Register  to view this content.

Thanks! It stopped before changing anything again, didn't even go into the if loop, which made me understand that the if loop didn't kick in at all because it couldn't find the link text. Figured out it was because of the link containing spaces, which I had copy-pasted into the code as %20, which the search string of course didn't find. Thanks for the help, I got all the links changed, and I also got to brush up a bit on my very limited VBA knowlegde

I guess you're not all that helpless Heel erg bedankt!