|
- Sub Getcy365_20()
- Dim StrRes$, Url$, I&, K&
- I = 1
- K = 2
- Do
- Url = "http://www.cy365.com/shop/category-20-sortID-desc-image-" & I & "-0.html "
- With CreateObject("MSXML2.XMLHTTP")
- .Open "GET", Url, False
- .setRequestHeader "If-Modified-Since", "0"
- .Send
- Do While .ReadyState <> 4
- DoEvents
- Loop
- StrRes = .ResponseText
- End With
-
- Dim LN, TLN, T
- 'Set odom = CreateObject("HTMLFILE")
- Dim oDom As New HTMLDocument
- oDom.body.innerHTML = StrRes
- Set TLN = oDom.getElementsByClassName("text")
- For Each T In TLN
- K = K + 1
- Cells(K, 1) = Trim(Split(T.innerText, vbCrLf)(0))
- Cells(K, 2) = Trim(Split(T.innerText, vbCrLf)(1))
- Cells(K, 3) = Trim(Split(T.innerText, vbCrLf)(2))
- Next
- Stop
- I = I + 1
- Debug.Print oDom.getElementsByClassName("box")(0).innerText
- Loop While oDom.getElementsByClassName("box")(0).innerText = "下一页"
- End Sub
复制代码 |
|