文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 计算机软件及应用 > excel汉字转换成拼音宏代码
侵权投诉

excel汉字转换成拼音宏代码

Function PinYin(Hz As String)

Dim PinMa As String

Dim MyPinMa As Variant

Dim Temp As Integer, i As Integer, j As Integer

PinMa = "a,20319,ai,20317,an,20304,ang,20295,ao,20292,"

PinMa = PinMa & "ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,20032,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19784,"

PinMa = PinMa & "ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,19725,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479,chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo,19224,"

PinMa = PinMa & "da,19218,dai,19212,dan,19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,"

PinMa = PinMa & "e,18710,en,18697,er,18696,"

PinMa = PinMa & "fa,18526,fan,18518,fang,18501,fei,18490,fen,18478,feng,18463,fo,18448,fou,18447,fu,18446," PinMa = PinMa & "ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang,17950,gui,17947,gun,17931,guo,17928,"

PinMa = PinMa & "ha,17922,hai,17759,han,17752,hang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,17427,"

PinMa = PinMa & "ji,17417,jia,17202,jian,17185,jiang,16983,jiao,16970,jie,16942,jin,16915,jing,16733,jiong,16708,jiu,16706,ju,16689,juan,16664,jue,16657,jun,16647,"

PinMa = PinMa & "ka,16474,kai,16470,kan,16465,kang,16459,kao,16452,ke,16448,ken,16433,keng,16429,kong,16427,kou,16423,ku,16419,kua,16412,kuai,16407,kuan,16403,kuang,16401,kui,16393,kun,16220,kuo,16216,"

PinMa = PinMa & "la,16212,lai,16205,lan,16202,lang,16187,lao,16180,le,16171,lei,16169,leng,16158,li,16155,lia,15959,lian,15958,liang,15944,liao,15933,lie,15920,lin,15915,ling,15903,liu,15889,long,15878,lou,15707,lu,15701,lv,15681,luan,15667,lue,15661,lun,15659,luo,15652,"

PinMa = PinMa & "ma,15640,mai,15631,man,15625,mang,15454,mao,15448,me,15436,mei,15435,men,15419,meng,15416,mi,15408,mian,15394,miao,15385,mie,15377,min,15375,ming,15369,miu,15363,mo,15362,mou,15183,mu,15180,"

PinMa = PinMa &

第1页

你可能喜欢

热门文档

相关文档

  • excel汉字转换成拼音宏代码

    excel汉字转换成拼音宏代码_计算机软件及应用_IT/计算机_专业资料。教你如何将EXCEL中汉字转换成拼音格式Function PinYin(Hz As String) Dim PinMa As String Dim...

  • excel 汉字转拼音首字母的宏程序代码

    excel 汉字转拼音首字母的宏程序代码 2011-03-16 21:33:01 分类: 默认分类 标签: 字号大中小 订阅 打开 Excel->工具->宏->Viaual Basic 编辑器 在弹...

  • excel中汉字转拼音的宏

    excel中汉字转拼音的宏_计算机软件及应用_IT/计算机_专业资料。excel中汉字转拼音的宏今日推荐 78份文档 不小心又胖了 胖女人必看...

  • excel_汉字转换成拼音简拼(只取首字母)

    在右面窗口中粘贴下面代码,直接关闭 窗口 3、输入公式=hztopy(A1),填充所有... excel汉字转换成拼音宏代... 2页 免费 excel汉字转换成拼音宏代... 3页 ...

  • 如何在excel中把汉字转换成拼音

    再双击插入的模块,进入模块代码编辑 状态; 4.将代码输入其中; 5.代码输入完成... excel汉字转换成拼音宏代... 2页 免费 在Excel中将中文转换成拼... 2页 ...

  • excel中汉字转拼音的宏

    excel中汉字转拼音的宏_交通运输_工程科技_专业资料。excel中汉字转拼音的宏PUBLIC FUNCTION PINYIN(CELL, Y, Z) AS VARIANT DIM MSG, STYLE, TITLE STYLE =...

  • excel 汉字转换成拼音全拼&excel 汉字转换成拼音简拼(...

    再双击插入的模块,进入模块代码编辑 状态; 4.将代码输入其中; 5.代码输入完成... excel汉字转换成拼音宏代... 2页 免费 excel中如何取汉字的拼音... 2页 ...

  • excel 汉字转换成拼音简拼(只取首字母)

    excel 汉字转换成拼音简拼(只取首字母)_计算机软件及应用_IT/计算机_专业资料。打开 Excel->工具->宏->Viaual Basic 编辑器 在弹出来的窗口中对着 VBAproject ...

  • 汉字转拼音宏

    excel汉字转换成拼音宏代... 2页 免费 姓名转换成拼音的宏 30页 免费 如何...指定的汉字转换为拼音,支...

  • 在excel中把汉字转换成拼音(只取首字母)

    在excel中把汉字转换成拼音(只取首字母)。execl 汉字 拼音 学籍在excel表格中把汉字转换成拼音,只取首字母打开Excel->工具->宏->Viaual Basic 编辑器 在弹...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email