ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 Excel Home精品图文教程库
HR薪酬管理数字化实战 Excel 2019函数公式学习大典 不用妈妈陪默写神器 打造核心竞争力的职场宝典
300集Office 2010微视频教程 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
你的Excel 2016实战技巧学习锦囊 WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 13551|回复: 27

[分享]好东西大家分享

[复制链接]

TA的精华主题

TA的得分主题

发表于 2004-7-29 19:20 | 显示全部楼层 |阅读模式

一段找出汉字首字母的代码,放到模快中

Function getpychar(char) tmp = 65536 + Asc(char) If (tmp >= 45217 And tmp <= 45252) Then getpychar = "A" ElseIf (tmp >= 45253 And tmp <= 45760) Then getpychar = "B" ElseIf (tmp >= 45761 And tmp <= 46317) Then getpychar = "C" ElseIf (tmp >= 46318 And tmp <= 46825) Then getpychar = "D" ElseIf (tmp >= 46826 And tmp <= 47009) Then getpychar = "E" ElseIf (tmp >= 47010 And tmp <= 47296) Then getpychar = "F" ElseIf (tmp >= 47297 And tmp <= 47613) Then getpychar = "G" ElseIf (tmp >= 47614 And tmp <= 48118) Then getpychar = "H" ElseIf (tmp >= 48119 And tmp <= 49061) Then getpychar = "J" ElseIf (tmp >= 49062 And tmp <= 49323) Then getpychar = "K" ElseIf (tmp >= 49324 And tmp <= 49895) Then getpychar = "L" ElseIf (tmp >= 49896 And tmp <= 50370) Then getpychar = "M" ElseIf (tmp >= 50371 And tmp <= 50613) Then getpychar = "N" ElseIf (tmp >= 50614 And tmp <= 50621) Then getpychar = "O" ElseIf (tmp >= 50622 And tmp <= 50905) Then getpychar = "P" ElseIf (tmp >= 50906 And tmp <= 51386) Then getpychar = "Q" ElseIf (tmp >= 51387 And tmp <= 51445) Then getpychar = "R" ElseIf (tmp >= 51446 And tmp <= 52217) Then getpychar = "S" ElseIf (tmp >= 52218 And tmp <= 52697) Then getpychar = "T" ElseIf (tmp >= 52698 And tmp <= 52979) Then getpychar = "W" ElseIf (tmp >= 52980 And tmp <= 53640) Then getpychar = "X" ElseIf (tmp >= 53689 And tmp <= 54480) Then getpychar = "Y" ElseIf (tmp >= 54481 And tmp <= 62289) Then getpychar = "Z" Else '如果不是中文,则不处理 getpychar = char End If End Function

Function getpy(str) For i = 1 To Len(str) getpy = getpy & getpychar(Mid(str, i, 1)) Next End Function

Sub jack() d = "只查我的" MsgBox getpy(d) End Sub

TA的精华主题

TA的得分主题

发表于 2004-7-29 21:51 | 显示全部楼层

多谢jack xhou老师!真是踏破铁鞋无觅处!

我找首字字母是用字库然后用函数查找引用弄得文件很大!

能否做一个附件传上来!

静候佳音!

TA的精华主题

TA的得分主题

 楼主| 发表于 2004-7-30 08:14 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2004-7-30 08:19 | 显示全部楼层

请问jack.zhou 兄如果要查整个汉字的拼音怎么办? 因为要排序的话,碰到姓的前一个拼音相同怎么办? 如: 甚至 到底谁在先呢?

TA的精华主题

TA的得分主题

发表于 2004-7-30 10:09 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2009-1-1 00:30 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2009-1-13 09:49 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2009-1-30 23:27 | 显示全部楼层

整理了一下(只修改了显示部份)

'===========================================================
Function getpychar(char)
tmp = 65536 + Asc(char)
If (tmp >= 45217 And tmp <= 45252) Then getpychar = "A" Else _
If (tmp >= 45253 And tmp <= 45760) Then getpychar = "B" Else _
If (tmp >= 45761 And tmp <= 46317) Then getpychar = "C" Else _
If (tmp >= 46318 And tmp <= 46825) Then getpychar = "D" Else _
If (tmp >= 46826 And tmp <= 47009) Then getpychar = "E" Else _
If (tmp >= 47010 And tmp <= 47296) Then getpychar = "F" Else _
If (tmp >= 47297 And tmp <= 47613) Then getpychar = "G" Else _
If (tmp >= 47614 And tmp <= 48118) Then getpychar = "H" Else _
If (tmp >= 48119 And tmp <= 49061) Then getpychar = "J" Else _
If (tmp >= 49062 And tmp <= 49323) Then getpychar = "K" Else _
If (tmp >= 49324 And tmp <= 49895) Then getpychar = "L" Else _
If (tmp >= 49896 And tmp <= 50370) Then getpychar = "M" Else _
If (tmp >= 50371 And tmp <= 50613) Then getpychar = "N" Else _
If (tmp >= 50614 And tmp <= 50621) Then getpychar = "O" Else _
If (tmp >= 50622 And tmp <= 50905) Then getpychar = "P" Else _
If (tmp >= 50906 And tmp <= 51386) Then getpychar = "Q" Else _
If (tmp >= 51387 And tmp <= 51445) Then getpychar = "R" Else _
If (tmp >= 51446 And tmp <= 52217) Then getpychar = "S" Else _
If (tmp >= 52218 And tmp <= 52697) Then getpychar = "T" Else _
If (tmp >= 52698 And tmp <= 52979) Then getpychar = "W" Else _
If (tmp >= 52980 And tmp <= 53640) Then getpychar = "X" Else _
If (tmp >= 53689 And tmp <= 54480) Then getpychar = "Y" Else _
If (tmp >= 54481 And tmp <= 62289) Then getpychar = "Z" Else getpychar = char  '如果不是中文,则不处理 End If
End Function
'--------------------------------------------
Function getpy(str)
For i = 1 To Len(str)
getpy = getpy & getpychar(Mid(str, i, 1))
Next
End Function
'--------------------------------------------
Sub jack()
d = "只查我的拼音字头"
MsgBox d
MsgBox d & Chr(10) & getpy(d)
End Sub
'===========================================================

[ 本帖最后由 guzhen9315 于 2009-1-31 00:03 编辑 ]

TA的精华主题

TA的得分主题

发表于 2009-4-23 00:44 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2009-4-23 08:45 | 显示全部楼层
不明白这个是作什么用的,是将汉字前加上第一个汉字的拼音首字母吗?
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-3-19 10:58 , Processed in 0.056678 second(s), 9 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表