|
本帖最后由 雪舞子 于 2016-10-15 21:12 编辑
“窗体班”时写的“快递速查系统”,
下午稍修改一下还能用,只需在“A2”单元格输入单号,无需输入快递公司即可查询跟单,
楼主可仿此加个循环即可实现批量快递查询。
现在是苹果收货季节,祝楼主大丰收发大财!
- Sub Test_XWZ()
- Dim strText$, kd(1), i%, dh$, s, cxArr(1 To 100, 1 To 2)
- Dim data As Object, context As Object, objJSON As Object
- On Error GoTo 100
- dh = Trim(Range("a2"))
- Set Cms = CreateObject("msscriptcontrol.scriptcontrol")
- With CreateObject("WinHttp.WinHttpRequest.5.1")
- .Open "POST", "https://www.kuaidi100.com/autonumber/autoComNum?text=" & dh, False
- .send
- strText = .responsetext
- With Cms
- .Language = "JavaScript"
- .AddCode "var mydata=" & strText
- Set objJSON = .CodeObject
- End With
- For Each s In objJSON.mydata.auto
- kd(i) = s.comCode
- i = i + 1
- Next
- .Open "GET", "https://www.kuaidi100.com/query?type=" & kd(0) & "&postid=" & dh & "&id=1&valicode=&temp=0.12300412077456713", False
- .send
- strText = .responsetext
- End With
- With Cms
- .Language = "JavaScript"
- .AddCode "var mydata=" & strText
- Set objJSON = .CodeObject
- End With
- i = 0
- For Each s In objJSON.mydata.data
- i = i + 1
- cxArr(i, 2) = s.context
- cxArr(i, 1) = s.ftime
- Next
- [b2:c1000]
- [b2].Resize(i, 2) = cxArr
- 100: If Err.Number Then MsgBox "无查询记录"
- End Sub
复制代码
参考附件
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|