|
楼主 |
发表于 2015-6-20 13:30
|
显示全部楼层
dsmch 发表于 2015-6-20 11:28
请教个问题 应该如何把你写的这段合并到 按钮1_Click() 这里面?
Sub 按钮1_Click()
Dim url, html
url = "http://www.1396.me/xyft/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
下面这段就是要合并到 按钮1_Click()
Sub Macro1()
Dim arr, brr, i&, s&
arr = Range("b1:b" & Range("b65536").End(xlUp).Row)
ReDim brr(1 To UBound(arr), 1 To 100)
With CreateObject("vbscript.regexp")
.Pattern = "\d+"
.Global = True
For i = 1 To UBound(arr)
s = 0
For Each m In .Execute(arr(i, 1))
s = s + 1: brr(i, s) = m
Next
If s > n Then n = s
Next
End With
Range("l1").Resize(UBound(brr), n) = brr
End Sub
|
|