Is it possible to edit hyperlinks via vba in Excel

[!Jumala!]

I am moving an Excel spreadsheet with about 3000 hyperlinks from C: drive to U: drive (server) and need to revise the hyperlinks accordingly. While I'm at it, I can take an unnecessary folder (....../folder/....) out of the address. I tried writing VBA to do this without success. Suggestions? Thank you in advance.

[Bontu]

Try this out :

Sub Fix192Hyperlinks()
Dim OldStr As String, NewStr As String
OldStr = "http://192.168.15.5/"
NewStr = "http://hank.home.on.ca/"
Dim hyp As Hyperlink
For Each hyp In ActiveSheet.Hyperlinks
hyp.Address = Replace(hyp.Address, OldStr, NewStr)
Next hyp
End Sub

If you want to fix the display text you can also include .TextToDisplay

[Shurod]

This is helpful but I think it doesn't solve my problem. It looks like this solution replaces old with new. I need to edit each hyp the same way (ie c:\target\folder\folder\filename to u:\target\folder\filename) because each hyp goes to a different file.