|
我把 url = "http://www.1396me.com/pk10/kaijiang"
改成 url = "http://www.1396me.com/gdkl10/kaijiang/"
就出现错误了 请高手帮忙看一下 谢谢
Sub 按钮1_Click()
Dim url, html
url = "http://www.1396me.com/pk10/kaijiang"
Set html = CreateObject("htmlfile")
With CreateObject("msxml2.xmlhttp")
.Open "GET", url, False
.send
html.body.innerhtml = .responsetext
Set tr = html.all.tags("tr")
For i = 0 To tr.Length - 1
If tr(i).classname = "odd" Or tr(i).classname = "even" Then
myno = ""
For j = 0 To tr(i).ChildNodes.Length - 1
If tr(i).ChildNodes(j).classname = "nums" Then
For Each no In tr(i).ChildNodes(j).ChildNodes
If myno = "" Then
myno = Replace(no.classname, "pk-no", "")
Else
myno = myno & "," & Replace(no.classname, "pk-no", "")
End If
Next
End If
Cells(i + 1, j + 1) = Replace(tr(i).ChildNodes(j).innertext, vbCrLf, " ")
Next
Cells(i + 1, 2) = myno
End If
Next
End With
End Sub
Sub 按钮2_Click()
Range("a2:j65536").ClearContents
End Sub
|
|