863
社区成员
发帖
与我相关
我的任务
分享
Dim basestr As String
Dim n36 As String
Dim n As Long
Dim L As Long
Dim i As Long
basestr = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"
n36 = "Z7"
n = 0
For i = 1 To Len(n36)
n = n * 36 + (InStr(basestr, Mid(n36, i, 1)) - 1)
Next
Debug.Print n