'函数功能:专门用于将日期转化为大写的字符
'调用方法:abc(date,string) date为要转化的日期,string为要转化的部分
' string参数为"y","m","d"
'开发人员:彭海涛
'开发时间:2006年12月30日
'大小写转换
Function aqq(pht As String) As String
Select Case pht
Case "0"
aqq = "零"
Case "1"
aqq = "壹"
Case "2"
aqq = "贰"
Case "3"
aqq = "叁"
Case "4"
aqq = "肆"
Case "5"
aqq = "伍"
Case "6"
aqq = "陆"
Case "7"
aqq = "柒"
Case "8"
aqq = "捌"
Case Else
aqq = "玖"
End Select
End Function
'通用日期数据大小写转换模块
Function abc(XYZ As Date, aa As String) As String
Dim j As String
Dim a As String '用于存储大写数字
Dim b As String '用于存储大写数字
Dim c As String '用于存储大写数字
Dim d As String '用于存储大写数字
Select Case aa
Case "y"
j = CStr(Format(XYZ, "yyyy"))
a = aqq(Mid(j, 1, 1))
b = aqq(Mid(j, 2, 1))
c = aqq(Mid(j, 3, 1))
d = aqq(Mid(j, 4, 1))
abc = a & b & c & d
Case "m"
j = CStr(Format(XYZ, "mm"))
a = aqq(Left(j, 1))
b = aqq(Right(j, 1))
abc = a & b
If Right(abc, 1) = "零" Then
abc = "零" & Left(abc, 1) & "拾"
End If
If Left(abc, 1) <> "零" Then
abc = Left(abc, 1) & "拾" & Right(abc, 1)
End If
Case Else
j = CStr(Format(XYZ, "dd"))
a = aqq(Left(j, 1))
b = aqq(Right(j, 1))
abc = a & b
If Right(abc, 1) = "零" Then
abc = "零" & Left(abc, 1) & "拾"
End If
If Left(abc, 1) <> "零" Then