数据表网址是动态的加一步吧 Sub test() Dim Arr, Arr1(), temp Dim i As Long With CreateObject("Microsoft.XMLHTTP") .Open "get", "http://video.shishicai.cn/Assist/BonusVideo.aspx?lt=4&isTransfer=ok", False .send temp = Split(Split(.responsetext, "iframeBonusRecent"" src=""")(1), """ style=""")(0) .Open "get", temp, False .send temp = Split(.responsetext, "<td>开奖号码</td>")(1) End With Arr = Split(temp, "<td>") For i = 0 To UBound(Arr) - 1 ReDim Preserve Arr1(0 To 1, 0 To i \ 2) Arr1(i Mod 2, i \ 2) = Split(Arr(i + 1), "</td>")(0) Next [A1].Resize(UBound(Arr1, 2), 2) = Application.WorksheetFunction.Transpose(Arr1) End Sub |