|
Private Declare Function LCMapString Lib "kernel32" Alias "LCMapStringA" (ByVal Locale As Long, _
ByVal dwMapFlags As Long, ByVal lpSrcStr As String, ByVal cchSrc As Long, ByVal lpDestStr As String, ByVal cchDest As Long) As Long
Private Declare Function lstrlen Lib "kernel32" Alias "lstrlenA" (ByVal lpString As String) As Long
Dim STf As String '繁体字符串
Dim STj As String ' 简体字符串
Dim STlen As Long ' 待转换字串长度
Sub Test1() 'Gb码简体转繁体
Dim i As Range
For Each i In Selection '根据所选区域依次转换
STj = i
STlen = lstrlen(STj)
STf = Space(STlen)
LCMapString &H804, &H4000000, STj, STlen, STf, STlen
i = STf
Next i
End Sub
Sub Test2() 'Gb码繁体转简体
Dim i As Range
For Each i In Selection '根据所选区域依次转换
STf = i
STlen = lstrlen(STf)
STj = Space(STlen)
LCMapString &H804, &H2000000, STf, STlen, STj, STlen
i = STj
Next i
End Sub
用法:创建两个按钮“繁转简”和“简转繁”,调用相应的代码。使用时先选择要转换的区域,再点击按钮。
|
|