|
本帖最后由 lhj323323 于 2011-10-16 19:37 编辑
老师:
最近在看您写的汉字转拼音的函数,当我把函数输入后,电脑提示:“编译错误:方法和数据成员未找到”,我错在哪儿呢?
用法:在模板的任一工作表的A列输入一组汉字,然后在B列的同一行输入函数公式=GetPy2(A1),即可获得汉字的拼音
下面是您写的程序:
程序中sDic = Sheet4.dic'报错
- Function GetPy2(ByVal Chs As String, Optional bList As Boolean = True) As String
- Dim stmp As String
- Dim sDic As String
- Dim arr() As String
- Dim i As Integer
- sDic = Sheet4.dic'这一句是什么意思?
- For i = 1 To IIf(bList, Len(Chs), 1)
- stmp = Mid(Chs, i, 1)
-
- arr = Split(sDic, "," + stmp)
-
- If UBound(arr) > 0 Then
- GetPy2 = GetPy2 & " " & Split(arr(1), ",")(0)
- Else
- GetPy2 = GetPy2 & " " & stmp
-
- End If
- Next
- GetPy2 = Trim(GetPy2)
- End Function
复制代码
- Sub 移动显示DIC()
- With Sheet1.dic
- .Top = [A9].Top
- .Left = [A9].Left
- .Width = 600
- .Height = 50
- .MultiLine = True
- End With
- End Sub
复制代码运行一次看看
|
|