unescape a URL

[gimme_this_gimme_that]

Is there a better way to unescape a URL? For now I'm getting by with
this but I'd like something more generic.

Thanks.

Function unescape(s As String)
s = Application.Substitute(s, "%20", " ")
s = Application.Substitute(s, "%3A", ":")
s = Application.Substitute(s, "%5C", "\")
unescape = s
End Function

 

[Sebation.G]

why not use the array formula
try:
=SUBSTITUTE(URL,{"%20","%3A","%5C"},{" ",":","\"})
HTH

 

[gimme_this_gimme_that]

It has to be a VBA solution. Thanks.

 

[Don Guillett]

replace

 

[NickHK]

There's the API call to UrlUnescape:
http://msdn2.microsoft.com/en-us/library/ms628645.aspx

And also its partner UrlEscape.

NickHK