|
我也来挖个坟
'接口:0工作日;1休息日;2节假日。
'包含2017年起的中国法定节假日数据,数据来源国务院发布的公告,每年更新
Function strFncWorkDay(strDay As String) As String
strFncWorkDay = "错误"
Dim strWebReturn As String
strWebReturn = strFncGetWebData("http://api.goseek.cn/Tools/holiday?date=" & strDay)
Dim arr
arr = Split(strWebReturn, ":")
Dim nFncDay As Integer
nFncDay = Left(arr(2), 1)
If nFncDay = 0 Then
strFncWorkDay = "工作日"
Else
strFncWorkDay = "节假日"
End If
End Function
Function strFncGetWebData(strUrl As String) As String
Dim objHttp As Object
Set objHttp = CreateObject("MSXML2.XMLHTTP.3.0")
objHttp.Open "GET", strUrl, False
objHttp.send
strFncGetWebData = objHttp.responseText
End Function |
|