利用了百度的opendata API接口,接口链接如下:
https://sp0.baidu.com/8aQDcjqpAAV3otqbppnN2DJv/api.php?query=2019&resource_id=6018
再去解析JSONfile,就可以获取节假日了。
代码如下:
Function GetJson()
Dim http
Dim aa As String
api = "https://sp0.baidu.com/8aQDcjqpAAV3otqbppnN2DJv/api.php?query=" & CStr(Year(Date)) & "&resource_id=6018"
Set http = CreateObject("Microsoft.XMLHTTP")
http.Open "POST", api, False
http.send ""
If http.Status = 200 Then
aa = http.responseText
GetJson = aa
Else
MsgBox "Cannot get api"
GetJson = ""