dizhicf(求魔法戦士エリクシルナイツ的下载地址)

分类: 游戏资讯 发布时间: 2024-06-10

大家好,dizhi cf相信很多的网友都不是很明白,包括求魔法戦士エリクシルナイツ的下载地址也是一样,不过没有关系,接下来就来为大家分享关于dizhi cf和求魔法戦士エリクシルナイツ的下载地址的一些知识点,大家可以关注收藏,免得下次来找不到哦,下面我们开始吧!

本文目录

  1. 我想要一个计算生辰八字的vb语言源码
  2. 91a61aae@bitsite.xyz这是什么邮箱
  3. 怎么在EXCEL用函数把公历日期变成阴历
  4. 敬请VBA大师帮忙解决VBA代码不能运行的问题
  5. 向大侠们求一个Excel2003公历转农历的函数公式
  6. 求魔法戦士エリクシルナイツ的下载地址
  7. 刺陵在线观看

我想要一个计算生辰八字的vb语言源码

这个是有计算方法的,只要你有计算公式我就可以计算出来的。但是前提你要有计算公式才行。

'公历转农历模块

'//农历数据定义//

'先以H2B函数还原成长度为18的字符串,其定义如下:

'前12个字节代表1-12月:1为大月,0为小月;压缩成十六进制(1-3位)

'第13位为闰月的情况,1为大月30天,0为小月29天;(4位)

'第14位为闰月的月份,如果不是闰月为0,否则给出月份(5位)

'最后4位为当年农历新年的公历日期,如0131代表1月31日;当作数值转十六进制(6-7位)

'农历常量(1899~2100,共202年)

PrivateConstylData="AB500D2,4BD0883,"_

&"4AE00DB,A5700D0,54D0581,D2600D8,D9500CC,655147D,56A00D5,9AD00CA,55D027A,4AE00D2,"_

&"A5B0682,A4D00DA,D2500CE,D25157E,B5500D6,56A00CC,ADA027B,95B00D3,49717C9,49B00DC,"_

&"A4B00D0,B4B0580,6A500D8,6D400CD,AB5147C,2B600D5,95700CA,52F027B,49700D2,6560682,"_

&"D4A00D9,EA500CE,6A9157E,5AD00D6,2B600CC,86E137C,92E00D3,C8D1783,C9500DB,D4A00D0,"_

&"D8A167F,B5500D7,56A00CD,A5B147D,25D00D5,92D00CA,D2B027A,A9500D2,B550781,6CA00D9,"_

&"B5500CE,535157F,4DA00D6,A5B00CB,457037C,52B00D4,A9A0883,E9500DA,6AA00D0,AEA0680,"_

&"AB500D7,4B600CD,AAE047D,A5700D5,52600CA,F260379,D9500D1,5B50782,56A00D9,96D00CE,"_

&"4DD057F,4AD00D7,A4D00CB,D4D047B,D2500D3,D550883,B5400DA,B6A00CF,95A1680,95B00D8,"_

&"49B00CD,A97047D,A4B00D5,B270ACA,6A500DC,6D400D1,AF40681,AB600D9,93700CE,4AF057F,"_

&"49700D7,64B00CC,74A037B,EA500D2,6B50883,5AC00DB,AB600CF,96D0580,92E00D8,C9600CD,"_

&"D95047C,D4A00D4,DA500C9,755027A,56A00D1,ABB0781,25D00DA,92D00CF,CAB057E,A9500D6,"_

&"B4A00CB,BAA047B,B5500D2,55D0983,4BA00DB,A5B00D0,5171680,52B00D8,A9300CD,795047D,"_

&"6AA00D4,AD500C9,5B5027A,4B600D2,96E0681,A4E00D9,D2600CE,EA6057E,D5300D5,5AA00CB,"_

&"76A037B,96D00D3,4AB0B83,4AD00DB,A4D00D0,D0B1680,D2500D7,D5200CC,DD4057C,B5A00D4,"_

&"56D00C9,55B027A,49B00D2,A570782,A4B00D9,AA500CE,B25157E,6D200D6,ADA00CA,4B6137B,"_

&"93700D3,49F08C9,49700DB,64B00D0,68A1680,EA500D7,6AA00CC,A6C147C,AAE00D4,92E00CA,"_

&"D2E0379,C9600D1,D550781,D4A00D9,DA400CD,5D5057E,56A00D6,A6C00CB,55D047B,52D00D3,"_

&"A9B0883,A9500DB,B4A00CF,B6A067F,AD500D7,55A00CD,ABA047C,A5A00D4,52B00CA,B27037A,"_

&"69300D1,7330781,6AA00D9,AD500CE,4B5157E,4B600D6,A5700CB,54E047C,D1600D2,E960882,"_

&"D5200DA,DAA00CF,6AA167F,56D00D7,4AE00CD,A9D047D,A2D00D4,D1500C9,F250279,D5200D1"

PrivateConstylMd0="初一初二初三初四初五初六初七初八初九初十十一十二十三十四十五"_

&"十六十七十八十九二十廿一廿二廿三廿四廿五廿六廿七廿八廿九三十"

PrivateConstylMn0="正二三四五六七八九十冬腊"

PrivateConstylTianGan0="甲乙丙丁戊已庚辛壬癸"

PrivateConstylDiZhi0="子丑寅卯辰巳午未申酉戌亥"

PrivateConstylShu0="鼠牛虎兔龙蛇马羊猴鸡狗猪"

'公历日期转农历

FunctionGetYLDate(ByValstrDateAsString)AsString

OnErrorGoToaErr

IfNotIsDate(strDate)ThenExitFunction

DimsetDateAsDate,tYearAsInteger,tMonthAsInteger,tDayAsInteger

setDate=CDate(strDate)

tYear=Year(setDate):tMonth=Month(setDate):tDay=Day(setDate)

'如果不是有效有日期,退出

IftYear>2100OrtYear<1900ThenExitFunction

DimdaList()AsString*18,conDateAsDate,thisMonthsAsString

DimAddYearAsInteger,AddMonthAsInteger,AddDayAsInteger,getDayAsInteger

DimYLyearAsString,YLShuXingAsString

Dimdd0AsString,mm0AsString,ganzhi(0To59)AsString*2

DimRunYueAsBoolean,RunYue1AsInteger,mDaysAsInteger,iAsInteger

'加载2年内的农历数据

ReDimdaList(tYear-1TotYear)

daList(tYear-1)=H2B(Mid(ylData,(tYear-1900)*8+1,7))

daList(tYear)=H2B(Mid(ylData,(tYear-1900+1)*8+1,7))

AddYear=tYear

initYL:

AddMonth=CInt(Mid(daList(AddYear),15,2))

AddDay=CInt(Mid(daList(AddYear),17,2))

conDate=DateSerial(AddYear,AddMonth,AddDay)'农历新年日期

getDay=DateDiff("d",conDate,setDate)+1'相差天数

IfgetDay<1ThenAddYear=AddYear-1:GoToinitYL

thisMonths=Left(daList(AddYear),14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

EndIf

thisMonths=Left(thisMonths,13)

Fori=1To13'计算天数

mDays=29+CInt(Mid(thisMonths,i,1))

IfgetDay>mDaysThen

getDay=getDay-mDays

Else

IfRunYue1>0Then

Ifi=RunYue1+1ThenRunYue=True

Ifi>RunYue1Theni=i-1

EndIf

AddMonth=i

AddDay=getDay

ExitFor

EndIf

Next

dd0=Mid(ylMd0,(AddDay-1)*2+1,2)

mm0=Mid(ylMn0,AddMonth,1)+"月"

Fori=0To59

ganzhi(i)=Mid(ylTianGan0,(iMod10)+1,1)+Mid(ylDiZhi0,(iMod12)+1,1)

Nexti

YLyear=ganzhi((AddYear-4)Mod60)

YLShuXing=Mid(ylShu0,((AddYear-4)Mod12)+1,1)

IfRunYueThenmm0="闰"&mm0

GetYLDate="农历"&YLyear&"("&YLShuXing&")年"&mm0&dd0

aErr:

EndFunction

'农历转公历日期

'secondMonth为真,则天示当tMonth是闰月时,取第二个月

FunctionGetDate(ByValtYearAsInteger,tMonthAsInteger,tDayAsInteger,OptionalsecondMonthAsBoolean=False)AsString

OnErrorGoToaErr

IftYear>2100OrtYear<1899OrtMonth>12OrtMonth<1OrtDay>30OrtDay<1ThenExitFunction

DimthisMonthsAsString,ylNewYearAsDate,toMonthAsInteger

DimmDaysAsInteger,RunYue1AsInteger,iAsInteger

thisMonths=H2B(Mid(ylData,(tYear-1899)*8+1,7))

IftDay>29+CInt(Mid(thisMonths,tMonth,1))ThenExitFunction

ylNewYear=DateSerial(tYear,CInt(Mid(thisMonths,15,2)),CInt(Mid(thisMonths,17,2)))'农历新年日期

thisMonths=Left(thisMonths,14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

toMonth=tMonth-1

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

IftMonth>RunYue1Or(secondMonthAndtMonth=RunYue1)ThentoMonth=tMonth

EndIf

thisMonths=Left(thisMonths,13)

mDays=0

Fori=1TotoMonth

mDays=mDays+29+CInt(Mid(thisMonths,i,1))

Next

mDays=mDays+tDay

GetDate=ylNewYear+mDays-1

aErr:

EndFunction

'将压缩的阴历字符还原

PrivateFunctionH2B(ByValstrHexAsString)AsString

DimiAsInteger,i1AsInteger,tmpVAsString

ConsthStr="0123456789ABCDEF"

ConstbStr="0000000100100011010001010110011110001001101010111100110111101111"

tmpV=UCase(Left(strHex,3))

'十六进制转二进制

Fori=1ToLen(tmpV)

i1=InStr(hStr,Mid(tmpV,i,1))

H2B=H2B&Mid(bStr,(i1-1)*4+1,4)

Next

H2B=H2B&Mid(strHex,4,2)

'十六进制转十进制

H2B=H2B&"0"&CStr(Val("&H"&Right(strHex,2)))

EndFunction

PrivateSubCommand1_Click()

Label1.Caption=GetYLDate(Text1.Text)

EndSub

91a61aae@bitsite.xyz这是什么邮箱

bitsite.xyz服务器iPbitsite.xyz域名解析bitsite.xyziP查询...

bitsite.xyz服务器iP:当前解析:网站劫持真机检测历史解析记录:2020-11-16---2022-11-18101.32.21.2042022-08-15---2022-08-2043.154...

查询网

@brjz.xyz是什么邮箱?-百度知道

1个回答回答时间:2020年7月6日

最佳回答:这个就是xyz域名的邮箱,.xyz是新顶级域名,全球面世时间为2014年6月2日。

百度知道

bitsite.xyz域名信息查询bitsite.xyzWhois信息bitsite.xyz域名...

9天前快照bitsite.xyzWhois域名信息查询whois服务器远程获取超时,请稍后重试whois监控最新域名查询www.95c8.com

查询网

bitsite.xyz子域名大全bitsite.xyz二级域名bitsite.xyz域名...

11月12日iP子域名备案bitsite.xyz更多子域名最新域名查询www.tutu520.comwww.1024.appgsbsjmc.comwww.ebcbdc.com...

查询网

91地址自动回复的邮箱号是多少-百度知道

1个回答回答时间:2022年4月23日

最佳回答:91邮箱号是http://mail.91.com。自动回复设置方法是首先登录你的TOMVIP邮箱,进入邮箱点击设置,邮箱...

百度知道

有谁知道@xyz.com是什么邮箱啊!帮个忙-王朝网络-zhidao...

2010年6月16日估计是xyz.com管理员的帐号(也有可能是内部用的邮箱,象baidu就有专用的邮箱)小贴士:①若网友所发内容与教科书相悖,请以教科书为准;②...

王朝网络

北京理工大学邮件系统

帐号登录用户登录自动启用SSL安全登录

北京理工大学邮件系统

91MikeWebmail是什么邮箱?-百度知道

4个回答回答时间:2021年4月29日

最佳回答:Web邮箱又叫“Webmail”,它并不是一个具体的邮箱,而是代替用户接收、发送邮件的功能。相较于其他e-mail邮箱没有那么多的配置,...

百度知道

这是个什么邮箱地址-百度知道

4个回答回答时间:2014年11月26日

最佳回答:你好,这个是126的邮箱在很多网页中,客户防止人被黑客利用,会将邮箱中的@用其他符号代替你这个邮箱:lir191@126.com千际为...

百度知道

常用邮箱、网盘地址列表-weixin-34151004的博客-CSDN博客

2011年7月20日91免费邮箱http://mail.91.com3126免费邮箱http://www.3126.com/阿里巴巴免费邮箱http://china.alibaba.com...

CSDN编程社区

晒一下我收到的91论坛邮件

1楼:一下我收到的91论坛邮件发信站:水木社区(ThuApr2515:18:142019...

2楼:一下我收到的91论坛邮件发信站:水木社区(ThuApr2515:18:38...

3楼:一下我收到的91论坛邮件发信站:水木社区(ThuApr2515:20:14...

水木社区

91找事网邮箱格式是什么样的-百度知道

1个回答回答时间:2015年1月28日

最佳回答:比如QQ邮箱地址:QQ号@qq.com,支持设置为【英文@qq.com】【手机@qq.com】【用户名@foxmail.com】商务两用,这个功能是实现一个...

百度知道

91dizhi.email子域名大全91dizhi.email二级域名91dizhi.email...

8天前com.gmail.at.91dizhi.email更多子域名最新域名查询yx8998.comwww88888.com...

查询网

91dizhi.email服务器iP91dizhi.email域名解析91dizhi.emailiP...

iP或域名查询XiP子域名备案91dizhi.email服务器iP:当前解析:网站劫持真机检测历史解析记录:2022-03-19---2022-03-19198.58.118....

查询网

91新地址怎么发邮件-天奇生活

1.在浏览器中输入平台网址,进入平台首页,点击【立即试用】,进入用户注册界面,输入账号密码,注册用户信息。

2.登录系统后,点击【发信设置】,设置发信人昵称,和专有发信域名。

3.点击【发件相关】,地址列表,点击【新建按钮】,进入新建地址列表页面。

天奇生活

91bi.com子域名大全91bi.com二级域名91bi.com域名解析查询

www.91bi.com更多子域名最新域名查询www.habo55.com75u8.comwww.dsn565.comwww.423.comhttpswww.747.com...

查询网

91M.com免费邮箱,支持10M超大附件-IDC资讯中心

2006年7月11日提供个性化域名选择与申请高速安全稳定,多级过滤系统环保型界面,清晰整洁91邮箱除了向用户提供十四个不同的个性域名选择外,还支持团体用户根...

西部数码

求求来个人帮个忙,看看这个是什么邮箱,有没有登录邮箱的地址

11月11日有哪个大佬知道这个邮箱是什么邮箱的域名地址啊,我一直找不到本文禁止转载或摘编分享到:投诉或建议推荐文章更多精彩内容...

哔哩哔哩

石墨烯-道客巴巴

SlUcyfX+lc74L1a91fw2Ly/dJpxPMgZECBwpIHAyO3bNcle+IdbspIrq/Vonkl+1RRFpSsO+MqImwmG/vbeSDQFj03oiZ/2aMc49v61yWianqml+GJjfW4nSz...

道客阅读

126网易免费邮-你的专业电子邮局

网易126免费邮箱–你的专业电子邮局,超过20年的邮箱运营经验,系统快速稳定安全,支持超大...

网易126免费邮

RGB(166,26,174),#A61AAE颜色查询,颜色梯度,色彩搭配,色盲模拟...

字客网RGB颜色查询在线工具是一款功能强大的RGB颜色查询工具,包括对应CMYK、RGB、HSL、HSV、XYZ等色彩空间的色值,颜色梯度、色彩搭配、色盲模拟。

字客网

...3130-455c-bf82-726c4cf4aa30&appUrlFlag=ztb001&siteGuid=7...

589ReFlkUyfCnpxlj4Ae4sHqyVYb20EqaSEkxOEq1T6UPs4CxwQJ0MkjUXyztGPMZnxeq1NRYyes7cB29aJc5jr7/lQYFZ4qqNocuqMOq0UG3+rcqS7AnE22...

四平市公共资源交易网

...b28c-4d36-aea3-b25c4b682813&appUrlFlag=scztb001&siteGuid=...

DMCPFi0V5VsMUZ4yOvik2S+RWSP1NUNuCUItqCNdOTT4SBTwFqCtG8G91pdTo74g5BCVXYzXwuS2OCYmFqrDfmFnvSHF9ZUbviPRZba8M0zmp381JvVQzN9I7l14r...

四川省公共资源交易信息网

...3dcf-48dc-8832-0e1a93843a19&appUrlFlag=ztb581&siteGuid=7...

LM7Sz3XB4m6FsaHFk2nhXgYWJp3uz4J5NdTLRwMfn2EUUiqB3Wafo5lt61J8Mbx00nCfvLkj0A/Eju91v77248P1byIBWFF66Oakfw40rXsMf6Pa3nJzIUtIpW9mm...

苏州市公共资源交易平台

ggzyjyzx.tl.gov.cn/tlsggzy/AttachStorage/6e1b8ee2-ca1e-4dcd...

gL9geTt0Sp2IuDMl+u93w09QON57vBXqqUrNAZuaNLp/5OGihD6pJmF8Uq2xqM+/5cn1LL8nTswbAKwlw91KcBdzkMepPVMpOYYJDQwZYDQY/OD932JummUdEFI...

ggzyjyzx.tl.gov.cn

...50e9-4dc3-91b4-2f13064e215d/[A3303820540001552001001]乐清...

l4wOgbC5FbI3X8eT1wqyAaEZLgNsfA50whdHfDLdiwnnYq6aQbmKlSd4RzXw6bfcnNq8VyGVRHLtGnk4Gq0xS3kBXjIGQ91ZYFaguyPDiu3ZPsQh4n6l13sNW0vdt...

ggzy.yueqing.gov.cn

做糖醋菜,记住这个比例,酸甜可口不油不腻,做啥菜都好吃

1.勺淀粉搅匀后煮至冒泡。打开新浪新闻8、把炸好的豆皮卷放入锅中翻炒均匀,让每一个豆皮卷都均匀裹满糖醋汁,就可以熄火了。打开

2.\u30012\u5f20\u8c46\u8150\u8863\u7528\u6e29\u6c34\u6ce1\u8f6f\uff0c\u6ce1\u7684\u65f6\u95f4

新浪网

12CRAC故障分析-ORA-17503:ksfdopn:2Failedtoopen

怎么在EXCEL用函数把公历日期变成阴历

公历转农历模块

'原创:互联网

'修正:阿勇2005/1/12

'//农历数据定义//

'先以H2B函数还原成长度为18的字符串,其定义如下:

'前12个字节代表1-12月:1为大月,0为小月;压缩成十六进制(1-3位)

'第13位为闰月的情况,1为大月30天,0为小月29天;(4位)

'第14位为闰月的月份,如果不是闰月为0,否则给出月份(5位)

'最后4位为当年农历新年的公历日期,如0131代表1月31日;当作数值转十六进制(6-7位)

'农历常量(1899~2100,共202年)

PrivateConstylData="AB500D2,4BD0883,"_

&"4AE00DB,A5700D0,54D0581,D2600D8,D9500CC,655147D,56A00D5,9AD00CA,55D027A,4AE00D2,"_

&"A5B0682,A4D00DA,D2500CE,D25157E,B5500D6,56A00CC,ADA027B,95B00D3,49717C9,49B00DC,"_

&"A4B00D0,B4B0580,6A500D8,6D400CD,AB5147C,2B600D5,95700CA,52F027B,49700D2,6560682,"_

&"D4A00D9,EA500CE,6A9157E,5AD00D6,2B600CC,86E137C,92E00D3,C8D1783,C9500DB,D4A00D0,"_

&"D8A167F,B5500D7,56A00CD,A5B147D,25D00D5,92D00CA,D2B027A,A9500D2,B550781,6CA00D9,"_

&"B5500CE,535157F,4DA00D6,A5B00CB,457037C,52B00D4,A9A0883,E9500DA,6AA00D0,AEA0680,"_

&"AB500D7,4B600CD,AAE047D,A5700D5,52600CA,F260379,D9500D1,5B50782,56A00D9,96D00CE,"_

&"4DD057F,4AD00D7,A4D00CB,D4D047B,D2500D3,D550883,B5400DA,B6A00CF,95A1680,95B00D8,"_

&"49B00CD,A97047D,A4B00D5,B270ACA,6A500DC,6D400D1,AF40681,AB600D9,93700CE,4AF057F,"_

&"49700D7,64B00CC,74A037B,EA500D2,6B50883,5AC00DB,AB600CF,96D0580,92E00D8,C9600CD,"_

&"D95047C,D4A00D4,DA500C9,755027A,56A00D1,ABB0781,25D00DA,92D00CF,CAB057E,A9500D6,"_

&"B4A00CB,BAA047B,B5500D2,55D0983,4BA00DB,A5B00D0,5171680,52B00D8,A9300CD,795047D,"_

&"6AA00D4,AD500C9,5B5027A,4B600D2,96E0681,A4E00D9,D2600CE,EA6057E,D5300D5,5AA00CB,"_

&"76A037B,96D00D3,4AB0B83,4AD00DB,A4D00D0,D0B1680,D2500D7,D5200CC,DD4057C,B5A00D4,"_

&"56D00C9,55B027A,49B00D2,A570782,A4B00D9,AA500CE,B25157E,6D200D6,ADA00CA,4B6137B,"_

&"93700D3,49F08C9,49700DB,64B00D0,68A1680,EA500D7,6AA00CC,A6C147C,AAE00D4,92E00CA,"_

&"D2E0379,C9600D1,D550781,D4A00D9,DA400CD,5D5057E,56A00D6,A6C00CB,55D047B,52D00D3,"_

&"A9B0883,A9500DB,B4A00CF,B6A067F,AD500D7,55A00CD,ABA047C,A5A00D4,52B00CA,B27037A,"_

&"69300D1,7330781,6AA00D9,AD500CE,4B5157E,4B600D6,A5700CB,54E047C,D1600D2,E960882,"_

&"D5200DA,DAA00CF,6AA167F,56D00D7,4AE00CD,A9D047D,A2D00D4,D1500C9,F250279,D5200D1"

PrivateConstylMd0="初一初二初三初四初五初六初七初八初九初十十一十二十三十四十五"_

&"十六十七十八十九二十廿一廿二廿三廿四廿五廿六廿七廿八廿九三十"

PrivateConstylMn0="正二三四五六七八九十冬腊"

PrivateConstylTianGan0="甲乙丙丁戊已庚辛壬癸"

PrivateConstylDiZhi0="子丑寅卯辰巳午未申酉戌亥"

PrivateConstylShu0="鼠牛虎兔龙蛇马羊猴鸡狗猪"

'公历日期转农历

FunctionGetYLDate(ByValstrDateAsString)AsString

OnErrorGoToaErr

IfNotIsDate(strDate)ThenExitFunction

DimsetDateAsDate,tYearAsInteger,tMonthAsInteger,tDayAsInteger

setDate=CDate(strDate)

tYear=Year(setDate):tMonth=Month(setDate):tDay=Day(setDate)

'如果不是有效有日期,退出

IftYear>2100OrtYear<1900ThenExitFunction

DimdaList()AsString*18,conDateAsDate,thisMonthsAsString

DimAddYearAsInteger,AddMonthAsInteger,AddDayAsInteger,getDayAsInteger

DimYLyearAsString,YLShuXingAsString

Dimdd0AsString,mm0AsString,ganzhi(0To59)AsString*2

DimRunYueAsBoolean,RunYue1AsInteger,mDaysAsInteger,iAsInteger

'加载2年内的农历数据

ReDimdaList(tYear-1TotYear)

daList(tYear-1)=H2B(Mid(ylData,(tYear-1900)*8+1,7))

daList(tYear)=H2B(Mid(ylData,(tYear-1900+1)*8+1,7))

AddYear=tYear

initYL:

AddMonth=CInt(Mid(daList(AddYear),15,2))

AddDay=CInt(Mid(daList(AddYear),17,2))

conDate=DateSerial(AddYear,AddMonth,AddDay)'农历新年日期

getDay=DateDiff("d",conDate,setDate)+1'相差天数

IfgetDay<1ThenAddYear=AddYear-1:GoToinitYL

thisMonths=Left(daList(AddYear),14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

EndIf

thisMonths=Left(thisMonths,13)

Fori=1To13'计算天数

mDays=29+CInt(Mid(thisMonths,i,1))

IfgetDay>mDaysThen

getDay=getDay-mDays

Else

IfRunYue1>0Then

Ifi=RunYue1+1ThenRunYue=True

Ifi>RunYue1Theni=i-1

EndIf

AddMonth=i

AddDay=getDay

ExitFor

EndIf

Next

dd0=Mid(ylMd0,(AddDay-1)*2+1,2)

mm0=Mid(ylMn0,AddMonth,1)+"月"

Fori=0To59

ganzhi(i)=Mid(ylTianGan0,(iMod10)+1,1)+Mid(ylDiZhi0,(iMod12)+1,1)

Nexti

YLyear=ganzhi((AddYear-4)Mod60)

YLShuXing=Mid(ylShu0,((AddYear-4)Mod12)+1,1)

IfRunYueThenmm0="闰"&mm0

GetYLDate="农历"&YLyear&"("&YLShuXing&")年"&mm0&dd0

aErr:

EndFunction

'农历转公历日期

'secondMonth为真,则天示当tMonth是闰月时,取第二个月

FunctionGetDate(ByValtYearAsInteger,tMonthAsInteger,tDayAsInteger,OptionalsecondMonthAsBoolean=False)AsString

OnErrorGoToaErr

IftYear>2100OrtYear<1899OrtMonth>12OrtMonth<1OrtDay>30OrtDay<1ThenExitFunction

DimthisMonthsAsString,ylNewYearAsDate,toMonthAsInteger

DimmDaysAsInteger,RunYue1AsInteger,iAsInteger

thisMonths=H2B(Mid(ylData,(tYear-1899)*8+1,7))

IftDay>29+CInt(Mid(thisMonths,tMonth,1))ThenExitFunction

ylNewYear=DateSerial(tYear,CInt(Mid(thisMonths,15,2)),CInt(Mid(thisMonths,17,2)))'农历新年日期

thisMonths=Left(thisMonths,14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

toMonth=tMonth-1

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

IftMonth>RunYue1Or(secondMonthAndtMonth=RunYue1)ThentoMonth=tMonth

EndIf

thisMonths=Left(thisMonths,13)

mDays=0

Fori=1TotoMonth

mDays=mDays+29+CInt(Mid(thisMonths,i,1))

Next

mDays=mDays+tDay

GetDate=ylNewYear+mDays-1

aErr:

EndFunction

'将压缩的阴历字符还原

PrivateFunctionH2B(ByValstrHexAsString)AsString

DimiAsInteger,i1AsInteger,tmpVAsString

ConsthStr="0123456789ABCDEF"

ConstbStr="0000000100100011010001010110011110001001101010111100110111101111"

tmpV=UCase(Left(strHex,3))

'十六进制转二进制

Fori=1ToLen(tmpV)

i1=InStr(hStr,Mid(tmpV,i,1))

H2B=H2B&Mid(bStr,(i1-1)*4+1,4)

Next

H2B=H2B&Mid(strHex,4,2)

'十六进制转十进制

H2B=H2B&"0"&CStr(Val("&H"&Right(strHex,2)))

EndFunction

敬请VBA大师帮忙解决VBA代码不能运行的问题

PrivateConstylData="AB500D2,4BD0883,"_

&"4AE00DB,A5700D0,54D0581,D2600D8,D9500CC,655147D,56A00D5,9AD00CA,55D027A,4AE00D2,"_

&"A5B0682,A4D00DA,D2500CE,D25157E,B5500D6,56A00CC,ADA027B,95B00D3,49717C9,49B00DC,"_

&"A4B00D0,B4B0580,6A500D8,6D400CD,AB5147C,2B600D5,95700CA,52F027B,49700D2,6560682,"_

&"D4A00D9,EA500CE,6A9157E,5AD00D6,2B600CC,86E137C,92E00D3,C8D1783,C9500DB,D4A00D0,"_

&"D8A167F,B5500D7,56A00CD,A5B147D,25D00D5,92D00CA,D2B027A,A9500D2,B550781,6CA00D9,"_

&"B5500CE,535157F,4DA00D6,A5B00CB,457037C,52B00D4,A9A0883,E9500DA,6AA00D0,AEA0680,"_

&"AB500D7,4B600CD,AAE047D,A5700D5,52600CA,F260379,D9500D1,5B50782,56A00D9,96D00CE,"_

&"4DD057F,4AD00D7,A4D00CB,D4D047B,D2500D3,D550883,B5400DA,B6A00CF,95A1680,95B00D8,"_

&"49B00CD,A97047D,A4B00D5,B270ACA,6A500DC,6D400D1,AF40681,AB600D9,93700CE,4AF057F,"_

&"49700D7,64B00CC,74A037B,EA500D2,6B50883,5AC00DB,AB600CF,96D0580,92E00D8,C9600CD,"_

&"D95047C,D4A00D4,DA500C9,755027A,56A00D1,ABB0781,25D00DA,92D00CF,CAB057E,A9500D6,"_

&"B4A00CB,BAA047B,B5500D2,55D0983,4BA00DB,A5B00D0,5171680,52B00D8,A9300CD,795047D,"_

&"6AA00D4,AD500C9,5B5027A,4B600D2,96E0681,A4E00D9,D2600CE,EA6057E,D5300D5,5AA00CB,"_

&"76A037B,96D00D3,4AB0B83,4AD00DB,A4D00D0,D0B1680,D2500D7,D5200CC,DD4057C,B5A00D4,"_

&"56D00C9,55B027A,49B00D2,A570782,A4B00D9,AA500CE,B25157E,6D200D6,ADA00CA,4B6137B,"_

&"93700D3,49F08C9,49700DB,64B00D0,68A1680,EA500D7,6AA00CC,A6C147C,AAE00D4,92E00CA,"_

&"D2E0379,C9600D1,D550781,D4A00D9,DA400CD,5D5057E,56A00D6,A6C00CB,55D047B,52D00D3,"_

&"A9B0883,A9500DB,B4A00CF,B6A067F,AD500D7,55A00CD,ABA047C,A5A00D4,52B00CA,B27037A,"_

&"69300D1,7330781,6AA00D9,AD500CE,4B5157E,4B600D6,A5700CB,54E047C,D1600D2,E960882,"_

&"D5200DA,DAA00CF,6AA167F,56D00D7,4AE00CD,A9D047D,A2D00D4,D1500C9,F250279,D5200D1"

PrivateConstylMd0="初一初二初三初四初五初六初七初八初九初十十一十二十三十四十五"_

&"十六十七十八十九二十廿一廿二廿三廿四廿五廿六廿七廿八廿九三十"

PrivateConstylMn0="正二三四五六七八九十冬腊"

PrivateConstylTianGan0="甲乙丙丁戊己庚辛壬癸"

PrivateConstylDiZhi0="子丑寅卯辰巳午未申酉戌亥"

PrivateConstylShu0="鼠牛虎兔龙蛇马羊猴鸡狗猪"

'公历日期转农历

FunctionGetYLDate(ByValstrDateAsString)AsString

OnErrorGoToaErr

IfNotIsDate(strDate)ThenExitFunction

DimsetDateAsDate,tYearAsInteger,tMonthAsInteger,tDayAsInteger

setDate=CDate(strDate)

tYear=Year(setDate):tMonth=Month(setDate):tDay=Day(setDate)

'如果不是有效有日期,退出

IftYear>2100OrtYear<1900ThenExitFunction

DimdaList()AsString*18,conDateAsDate,thisMonthsAsString

DimAddYearAsInteger,AddMonthAsInteger,AddDayAsInteger,getDayAsInteger

DimYLyearAsString,YLShuXingAsString

Dimdd0AsString,mm0AsString,ganzhi(0To59)AsString*2

DimRunYueAsBoolean,RunYue1AsInteger,mDaysAsInteger,iAsInteger

'加载2年内的农历数据

ReDimdaList(tYear-1TotYear)

daList(tYear-1)=H2B(Mid(ylData,(tYear-1900)*8+1,7))

daList(tYear)=H2B(Mid(ylData,(tYear-1900+1)*8+1,7))

AddYear=tYear

initYL:

AddMonth=CInt(Mid(daList(AddYear),15,2))

AddDay=CInt(Mid(daList(AddYear),17,2))

conDate=DateSerial(AddYear,AddMonth,AddDay)'农历新年日期

getDay=DateDiff("d",conDate,setDate)+1'相差天数

IfgetDay<1ThenAddYear=AddYear-1:GoToinitYL

thisMonths=Left(daList(AddYear),14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

EndIf

thisMonths=Left(thisMonths,13)

Fori=1To13'计算天数

mDays=29+CInt(Mid(thisMonths,i,1))

IfgetDay>mDaysThen

getDay=getDay-mDays

Else

IfRunYue1>0Then

Ifi=RunYue1+1ThenRunYue=True

Ifi>RunYue1Theni=i-1

EndIf

AddMonth=i

AddDay=getDay

ExitFor

EndIf

Next

dd0=Mid(ylMd0,(AddDay-1)*2+1,2)

mm0=Mid(ylMn0,AddMonth,1)+"月"

Fori=0To59

ganzhi(i)=Mid(ylTianGan0,(iMod10)+1,1)+Mid(ylDiZhi0,(iMod12)+1,1)

Nexti

YLyear=ganzhi((AddYear-4)Mod60)

YLShuXing=Mid(ylShu0,((AddYear-4)Mod12)+1,1)

IfRunYueThenmm0="闰"&mm0

'GetYLDate=YLyear&"("&YLShuXing&")年"&mm0&dd0

GetYLDate=YLyear&"年"&mm0&dd0

aErr:

EndFunction

向大侠们求一个Excel2003公历转农历的函数公式

你的自定义函数有问题!发一个用VBA编写好的公农历转换函数给你吧!

'公历转农历模块

'原创:互联网

'修正:阿勇2005/1/12

'//农历数据定义//

'先以H2B函数还原成长度为18的字符串,其定义如下:

'前12个字节代表1-12月:1为大月,0为小月;压缩成十六进制(1-3位)

'第13位为闰月的情况,1为大月30天,0为小月29天;(4位)

'第14位为闰月的月份,如果不是闰月为0,否则给出月份(5位)

'最后4位为当年农历新年的公历日期,如0131代表1月31日;当作数值转十六进制(6-7位)

'农历常量(1899~2100,共202年)

PrivateConstylData="AB500D2,4BD0883,"_

&"4AE00DB,A5700D0,54D0581,D2600D8,D9500CC,655147D,56A00D5,9AD00CA,55D027A,4AE00D2,"_

&"A5B0682,A4D00DA,D2500CE,D25157E,B5500D6,56A00CC,ADA027B,95B00D3,49717C9,49B00DC,"_

&"A4B00D0,B4B0580,6A500D8,6D400CD,AB5147C,2B600D5,95700CA,52F027B,49700D2,6560682,"_

&"D4A00D9,EA500CE,6A9157E,5AD00D6,2B600CC,86E137C,92E00D3,C8D1783,C9500DB,D4A00D0,"_

&"D8A167F,B5500D7,56A00CD,A5B147D,25D00D5,92D00CA,D2B027A,A9500D2,B550781,6CA00D9,"_

&"B5500CE,535157F,4DA00D6,A5B00CB,457037C,52B00D4,A9A0883,E9500DA,6AA00D0,AEA0680,"_

&"AB500D7,4B600CD,AAE047D,A5700D5,52600CA,F260379,D9500D1,5B50782,56A00D9,96D00CE,"_

&"4DD057F,4AD00D7,A4D00CB,D4D047B,D2500D3,D550883,B5400DA,B6A00CF,95A1680,95B00D8,"_

&"49B00CD,A97047D,A4B00D5,B270ACA,6A500DC,6D400D1,AF40681,AB600D9,93700CE,4AF057F,"_

&"49700D7,64B00CC,74A037B,EA500D2,6B50883,5AC00DB,AB600CF,96D0580,92E00D8,C9600CD,"_

&"D95047C,D4A00D4,DA500C9,755027A,56A00D1,ABB0781,25D00DA,92D00CF,CAB057E,A9500D6,"_

&"B4A00CB,BAA047B,B5500D2,55D0983,4BA00DB,A5B00D0,5171680,52B00D8,A9300CD,795047D,"_

&"6AA00D4,AD500C9,5B5027A,4B600D2,96E0681,A4E00D9,D2600CE,EA6057E,D5300D5,5AA00CB,"_

&"76A037B,96D00D3,4AB0B83,4AD00DB,A4D00D0,D0B1680,D2500D7,D5200CC,DD4057C,B5A00D4,"_

&"56D00C9,55B027A,49B00D2,A570782,A4B00D9,AA500CE,B25157E,6D200D6,ADA00CA,4B6137B,"_

&"93700D3,49F08C9,49700DB,64B00D0,68A1680,EA500D7,6AA00CC,A6C147C,AAE00D4,92E00CA,"_

&"D2E0379,C9600D1,D550781,D4A00D9,DA400CD,5D5057E,56A00D6,A6C00CB,55D047B,52D00D3,"_

&"A9B0883,A9500DB,B4A00CF,B6A067F,AD500D7,55A00CD,ABA047C,A5A00D4,52B00CA,B27037A,"_

&"69300D1,7330781,6AA00D9,AD500CE,4B5157E,4B600D6,A5700CB,54E047C,D1600D2,E960882,"_

&"D5200DA,DAA00CF,6AA167F,56D00D7,4AE00CD,A9D047D,A2D00D4,D1500C9,F250279,D5200D1"

PrivateConstylMd0="初一初二初三初四初五初六初七初八初九初十十一十二十三十四十五"_

&"十六十七十八十九二十廿一廿二廿三廿四廿五廿六廿七廿八廿九三十"

PrivateConstylMn0="正二三四五六七八九十冬腊"

PrivateConstylTianGan0="甲乙丙丁戊已庚辛壬癸"

PrivateConstylDiZhi0="子丑寅卯辰巳午未申酉戌亥"

PrivateConstylShu0="鼠牛虎兔龙蛇马羊猴鸡狗猪"

'公历日期转农历

FunctionGetYLDate(ByValstrDateAsString)AsString

OnErrorGoToaErr

IfNotIsDate(strDate)ThenExitFunction

DimsetDateAsDate,tYearAsInteger,tMonthAsInteger,tDayAsInteger

setDate=CDate(strDate)

tYear=Year(setDate):tMonth=Month(setDate):tDay=Day(setDate)

'如果不是有效有日期,退出

IftYear>2100OrtYear<1900ThenExitFunction

DimdaList()AsString*18,conDateAsDate,thisMonthsAsString

DimAddYearAsInteger,AddMonthAsInteger,AddDayAsInteger,getDayAsInteger

DimYLyearAsString,YLShuXingAsString

Dimdd0AsString,mm0AsString,ganzhi(0To59)AsString*2

DimRunYueAsBoolean,RunYue1AsInteger,mDaysAsInteger,iAsInteger

'加载2年内的农历数据

ReDimdaList(tYear-1TotYear)

daList(tYear-1)=H2B(Mid(ylData,(tYear-1900)*8+1,7))

daList(tYear)=H2B(Mid(ylData,(tYear-1900+1)*8+1,7))

AddYear=tYear

initYL:

AddMonth=CInt(Mid(daList(AddYear),15,2))

AddDay=CInt(Mid(daList(AddYear),17,2))

conDate=DateSerial(AddYear,AddMonth,AddDay)'农历新年日期

getDay=DateDiff("d",conDate,setDate)+1'相差天数

IfgetDay<1ThenAddYear=AddYear-1:GoToinitYL

thisMonths=Left(daList(AddYear),14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

EndIf

thisMonths=Left(thisMonths,13)

Fori=1To13'计算天数

mDays=29+CInt(Mid(thisMonths,i,1))

IfgetDay>mDaysThen

getDay=getDay-mDays

Else

IfRunYue1>0Then

Ifi=RunYue1+1ThenRunYue=True

Ifi>RunYue1Theni=i-1

EndIf

AddMonth=i

AddDay=getDay

ExitFor

EndIf

Next

dd0=Mid(ylMd0,(AddDay-1)*2+1,2)

mm0=Mid(ylMn0,AddMonth,1)+"月"

Fori=0To59

ganzhi(i)=Mid(ylTianGan0,(iMod10)+1,1)+Mid(ylDiZhi0,(iMod12)+1,1)

Nexti

YLyear=ganzhi((AddYear-4)Mod60)

YLShuXing=Mid(ylShu0,((AddYear-4)Mod12)+1,1)

IfRunYueThenmm0="闰"&mm0

GetYLDate="农历"&YLyear&"("&YLShuXing&")年"&mm0&dd0

aErr:

EndFunction

'农历转公历日期

'secondMonth为真,则天示当tMonth是闰月时,取第二个月

FunctionGetDate(ByValtYearAsInteger,tMonthAsInteger,tDayAsInteger,OptionalsecondMonthAsBoolean=False)AsString

OnErrorGoToaErr

IftYear>2100OrtYear<1899OrtMonth>12OrtMonth<1OrtDay>30OrtDay<1ThenExitFunction

DimthisMonthsAsString,ylNewYearAsDate,toMonthAsInteger

DimmDaysAsInteger,RunYue1AsInteger,iAsInteger

thisMonths=H2B(Mid(ylData,(tYear-1899)*8+1,7))

IftDay>29+CInt(Mid(thisMonths,tMonth,1))ThenExitFunction

ylNewYear=DateSerial(tYear,CInt(Mid(thisMonths,15,2)),CInt(Mid(thisMonths,17,2)))'农历新年日期

thisMonths=Left(thisMonths,14)

RunYue1=Val("&H"&Right(thisMonths,1))'闰月月份

toMonth=tMonth-1

IfRunYue1>0Then'有闰月

thisMonths=Left(thisMonths,RunYue1)&Mid(thisMonths,13,1)&Mid(thisMonths,RunYue1+1)

IftMonth>RunYue1Or(secondMonthAndtMonth=RunYue1)ThentoMonth=tMonth

EndIf

thisMonths=Left(thisMonths,13)

mDays=0

Fori=1TotoMonth

mDays=mDays+29+CInt(Mid(thisMonths,i,1))

Next

mDays=mDays+tDay

GetDate=ylNewYear+mDays-1

aErr:

EndFunction

'将压缩的阴历字符还原

PrivateFunctionH2B(ByValstrHexAsString)AsString

DimiAsInteger,i1AsInteger,tmpVAsString

ConsthStr="0123456789ABCDEF"

ConstbStr="0000000100100011010001010110011110001001101010111100110111101111"

tmpV=UCase(Left(strHex,3))

'十六进制转二进制

Fori=1ToLen(tmpV)

i1=InStr(hStr,Mid(tmpV,i,1))

H2B=H2B&Mid(bStr,(i1-1)*4+1,4)

Next

H2B=H2B&Mid(strHex,4,2)

'十六进制转十进制

H2B=H2B&"0"&CStr(Val("&H"&Right(strHex,2)))

EndFunction

求魔法戦士エリクシルナイツ的下载地址

魔が堕ちる夜的下载地址(一部很好看的,比你的要好,我推荐一下)

【种子地址】:http://www1.19kkk.com/link.php?ref=4Jk3oZgZ6g

戦乙女ヴァルキリー全集

http://www.btfree.info/html/c408360f1410b42.html

参考资料http://www.baidu.com/baidu?sr=C661DE381130B0EA5167657452A9CDD0B468ECAC&tn=webxunlei_1_cb&word=%C4%A7%B7%A8%91%E9%CA%BF%A5%A8%A5%EA%A5%AF%A5%B7%A5%EB%A5%CA%A5%A4%A5%C4%B5%C4BT%CF%C2%D4%D8%B5%D8%D6%B7&bar=7

刺陵在线观看

链接:https://pan.baidu.com/s/1-Kiz9ojpjOMYe9G0B5Jgkg提取码:6g5w

《刺陵》是台湾导演朱延平执导的一部寻宝探险片,由周杰伦、林志玲、陈道明、曾志伟等主演,于2009年12月9日在中国上映。《刺陵》围绕大漠深处一座失落古城,讲述两个目的不同群体的寻宝探险故事。一群人努力保护古迹不被破坏,一群人企图探古寻宝谋得私利。

好了,文章到此结束,希望可以帮助到大家。

标签云