'清除日文片假名字符函数
Function ClearKatakana(Expression As String) As String
Dim i As Long
Dim lngStart As Long
Dim lngLength As Long
lngStart = 1
For i = 1 To Len(Expression)
Select Case Mid(Expression, i, 1)
Case "ゴ", "ガ", "ギ", "ア", "ゲ", "ザ", "ジ", "ズ", "ヅ", "デ", "ド", "ポ", "ベ", "プ", "ビ", "パ", "ヴ", "ボ", "ペ", "ブ", "ピ", "バ", "ヂ", "ダ", "ゾ", "ゼ"
lngLength = i - lngStart
If lngLength > 0 Then ClearKatakana = ClearKatakana & Mid(Expression, lngStart, lngLength)
lngStart = i + 1
End Select
Next
我把
Err_Command0_Click:
If Err.Number = 5 Then
b = EncodeString(k)
x = Replace(b, Chr(10) & "", Chr(13) & Chr(10))
Resume Next
else
msgbox err.number
resume next
End If
b = EncodeString(k)
换成b=ClearKatakana(k)
运行错误“6 ”,溢出
这一句: For i = 1 To Len(Expression) 作者: todaynew 时间: 2010-12-24 07:26