Vba怎么提取汉字“鑫、醴、鳌”拼音的大写首字母

Question

网上找的Vba代码目前发现提取不了这几个汉字的大写首字母，请问有什么办法解决的嘛？

Answer 1

汉字转拼单首字母

现在各种查询中，一般都支持拼音首字母查询，下面的函数可以获得汉字的首字母。
Public Function PY(myStr)
Dim Str$, L$, Temp$, 特殊字$
Str = Replace(Replace(myStr, " ", ""), "　", "")
dict = [{"吖","a";"八","b";"擦","c";"咑","d";"鵽","e";"发","f";"伽","g";"哈","h";"丌","j";"咔","k";"垃","l";"妈","m";"拿","n";"哦","o";"妑","p";"七","q";"然","r";"仨","s";"他","t";"屲","w";"夕","x";"丫","y";"帀","z"}]
特殊字 = "仇Q覃Q"
For i = 1 To Len(Str)L = Mid$(Str, i, 1)j = InStr(tmp, Mid(Str, i, 1))If L Like "[一-龥]" ThenTemp = Temp & IIf(j, Mid(特殊字, j + 1, 1), UCase(Application.Lookup(L, dict)))ElseTemp = Temp & LEnd If
Next i
PY = Temp
End Function