|
Sub getall()
Dim url As String, v() As String, s() As String
url = "http://u.115.com/folder/f9e1f2bb29/"
With CreateObject("Msxml2.XMLHTTP")
For p = 1 To 5
.Open "get", url & p, False
.send
Do While Not .readystate = 4
DoEvents
Loop
v = Filter(Split(.responsetext, vbCrLf), "<h5>")
For i = 0 To UBound(v)
s = Split(v(i), """")
n = n + 1
ActiveSheet.Hyperlinks.Add Anchor:=Cells(n, 1), Address:=s(3), TextToDisplay:=s(1)
Next
Next
End With
End Sub |
|
|