|
本帖最后由 chulia_wong 于 2015-10-25 14:23 编辑
求帮忙修改下网数据采集格式,代码已有,求修改:感激不尽!
!!!只要显示黄色背景的数据,其它的通通不要;然后把黄色数据倒序发送到单元格(模拟结果)!!!!
- Sub demo()
- Dim url$, str$, arr, nr, i%, brr, m%, n%, j%
- Application.ScreenUpdating = False
- url = "http://www.17500.cn/getData/ssq.TXT"
- With CreateObject("MSXML2.XMLHTTP")
- .Open "GET", url, False
- .send
- str = .responsetext
- arr = Split(str, Chr(10))
- ReDim brr(1 To UBound(arr), 1 To 8)
- For i = UBound(arr) - 1 To 0 Step -1
- m = m + 1
- nr = Split(arr(i), " ")
- n = 0
- For j = 0 To 8
- If j <> 1 Then
- n = n + 1
- brr(m, n) = nr(j)
- End If
- Next
- Next
- End With
- Sheets("模拟结果").Range("A3").Resize(UBound(brr), 8) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|