|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 wx486 于 2013-8-23 23:11 编辑
换了算法,代码如下。
- Sub xmlhttp()
- Dim arr, brr(1 To 10000, 1 To 8), i%, j%, k%, reg As Object, matches, ma
- Set reg = CreateObject("vbscript.regexp")
- With reg
- .Global = True
- .Pattern = ">([^<>]+)<"
- End With
- With CreateObject("msxml2.xmlhttp")
- .Open "post", "http://bf.bet007.com/Over_matchdate.aspx", False
- .SetRequestHeader "content-type", "application/x-www-form-urlencoded"
- .send "matchdate=" & [b1].Value & "&Submit=%B2%E9%D1%AF&team=&sclass="
- s = .responsetext
- End With
- arr = Filter(Split(Split(Split(s, "id=""schedule"">")(1), "</div>")(0), "<tr"), "</tr>")
- For i = 1 To UBound(arr)
- Set matches = reg.Execute(Replace(arr(i), " ", ""))
- If matches.Count > 3 Then
- k = k + 1
- If matches(2).submatches(0) = "推迟" Or matches(2).submatches(0) = "待定" Then
- For j = 1 To 4
- brr(k, j) = matches(j - 1).submatches(0)
- Next
- brr(k, 6) = matches(4).submatches(0)
- brr(k, 8) = "析亚欧"
- Else
- For j = 1 To 7
- brr(k, j) = matches(j - 1).submatches(0)
- Next
- brr(k, 8) = "析亚欧"
- End If
- End If
- Next
- [a1].CurrentRegion.Offset(2).ClearContents
- [a3].Resize(UBound(brr), 8) = brr
- MsgBox "ok"
- End Sub
复制代码 [tr]
|
|