只需把原来的代码简单改成下面这样就可以了
arr(i, 2) = Replace(Split(brr(i), """ tian=""")(0), ",", " ")
arr(i, 1) = Left(Split(brr(i), "expect=""")(1), 8)- Sub test()
- Dim akw rr(1 To 10000, 1 To 2), i&, brr
- With CreateObject("microsoft.xmlhttp")
- .Open "GET", "http://500wan.zone.tenpay.com/static/public/dlc/xml/historyopen.xml", False
- .send
- Do Until .readystate = 4
- DoEvents
- Loop
- brr = Split(.responsetext, "opencode=""")
- For i = 1 To UBound(brr)
- arr(i, 2) = Replace(Split(brr(i), """ tian=""")(0), ",", " ")
- arr(i, 1) = Left(Split(brr(i), "expect=""")(1), 8)
- Next
- End With
- Cells.ClearContents
- Range("a1:b" & i) = arr
- End Sub
复制代码 |