【散分】怎样用VB把汉字转为URI编码【已解决】

[DawnPine]

在URL地址中，一个汉字用 %XX%YY%ZZ 来表示，查了一下，好像这个是叫URI编码
求把汉字转为URI编码的办法。
如果在VBA中调用这个办法，需要引用哪些东西。
谢谢！

[DawnPine]

居然没人来答。。。。

研究了二年半，终于自己搞定了

Function UTF8EncodeURI(strUTF8 As String) As String
    Dim nFor    As Long
    Dim nAsc    As Long
    Dim strWchar    As String
    Dim strURIchar  As String
    
    UTF8EncodeURI = ""
    For nFor = 1 To Len(strUTF8)
        strWchar = Mid(strUTF8, nFor, 1)
        nAsc = AscW(strWchar)
        If nAsc < 0 Then nAsc = nAsc + 65536
        If (nAsc And &HFF80) = 0 Then
            UTF8EncodeURI = UTF8EncodeURI & strWchar
        ElseIf (nAsc And &HF000) = 0 Then
            strURIchar = "%" & Hex(((nAsc \ 2 ^ 6)) Or &HC0) & Hex(nAsc And &H3F Or &H80)
            UTF8EncodeURI = UTF8EncodeURI & strURIchar
        Else
            strURIchar = "%" & Hex((nAsc \ 2 ^ 12) Or &HE0) & _
                         "%" & Hex((nAsc \ 2 ^ 6) And &H3F Or &H80) & _
                         "%" & Hex(nAsc And &H3F Or &H80)
            UTF8EncodeURI = UTF8EncodeURI & strURIchar
        End If
    Next
End Function

[DawnPine]

Function UTF8EncodeURI(strUTF8 As String) As String
    Dim nFor    As Long
    Dim nAsc    As Long
    Dim strWchar    As String
    Dim strURIchar  As String
    
    UTF8EncodeURI = ""
    For nFor = 1 To Len(strUTF8)
        strWchar = Mid(strUTF8, nFor, 1)
        nAsc = AscW(strWchar)
        If nAsc < 0 Then nAsc = nAsc + 65536
        If (nAsc And &HFF80) = 0 Then
            UTF8EncodeURI = UTF8EncodeURI & strWchar
        ElseIf (nAsc And &HF000) = 0 Then
            strURIchar = "%" & Hex(((nAsc \ 2 ^ 6)) Or &HC0) & Hex(nAsc And &H3F Or &H80)
            UTF8EncodeURI = UTF8EncodeURI & strURIchar
        Else
            strURIchar = "%" & Hex((nAsc \ 2 ^ 12) Or &HE0) & _
                         "%" & Hex((nAsc \ 2 ^ 6) And &H3F Or &H80) & _
                         "%" & Hex(nAsc And &H3F Or &H80)
            UTF8EncodeURI = UTF8EncodeURI & strURIchar
        End If
    Next
End Function

[net_friends]

揭帖把

[秋杨]

嗯嗯~结贴吧

[DawnPine]

终于来人了
结帖
走人