Function Escape(ByVal Text As String) As String Dim s As String Dim ch As String Dim iAscii As Integer Dim i As Long
For i = 1 To Len(Text) ch = Mid$(Text, i, 1) Select Case ch Case "0" To "9", "a" To "z", "A" To "Z", _ "-", "_", ".", "!", "~", "*", "'", "(", ")" s = s & ch Case Else iAscii = AscW(ch) If (0 <= iAscii) And (iAscii < 255) Then s = s & ("%" & Right$("0" & Hex(iAscii), 2)) Else s = s & ("%u" & Right$("000" & Hex(iAscii), 4)) End If End Select Next
Dim s As String
Dim ch As String
Dim iAscii As Integer
Dim i As Long
For i = 1 To Len(Text)
ch = Mid$(Text, i, 1)
Select Case ch
Case "0" To "9", "a" To "z", "A" To "Z", _
"-", "_", ".", "!", "~", "*", "'", "(", ")"
s = s & ch
Case Else
iAscii = AscW(ch)
If (0 <= iAscii) And (iAscii < 255) Then
s = s & ("%" & Right$("0" & Hex(iAscii), 2))
Else
s = s & ("%u" & Right$("000" & Hex(iAscii), 4))
End If
End Select
Next
Escape = s
End Function