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

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

--
Regards,

Sebation.G

groups.com...
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

It has to be a VBA solution. Thanks.

replace


--
Don Guillett
SalesAid Software

wrote in message
ups.com...
It has to be a VBA solution. Thanks.

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

And also its partner UrlEscape.

NickHK

wrote in message
oups.com...
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