|
- Sub getifo()
- Dim str As String
- Dim t
- t = Timer
- For m = 2 To Sheets("URL").Range("A1048576").End(xlUp).Row
- URL = Sheets("URL").Cells(m, 1)
- With CreateObject("internetexplorer.application")
- .Navigate URL
- While .busy Or .readystate <> 4: Wend
- On Error Resume Next
- Sheets("数据表").Cells(m, "A") = .Document.getElementsByTagName("TD")(2405).innertext
- Sheets("数据表").Cells(m, "B") = .Document.getElementsByTagName("TD")(2407).innertext
- Sheets("数据表").Cells(m, "C") = .Document.getElementsByTagName("TD")(2409).innertext
- Sheets("数据表").Cells(m, "D") = .Document.getElementsByTagName("TD")(2411).innertext
- Sheets("数据表").Cells(m, "E") = .Document.getElementsByTagName("TD")(2413).innertext
- Sheets("数据表").Cells(m, "F") = .Document.getElementsByTagName("TD")(2415).innertext
- Sheets("数据表").Cells(m, "G") = .Document.getElementsByTagName("TD")(2417).innertext
- Sheets("数据表").Cells(m, "H") = .Document.getElementsByTagName("TD")(2419).innertext
- Sheets("数据表").Cells(m, "I") = .Document.getElementsByTagName("TD")(2421).innertext
- Sheets("数据表").Cells(m, "J") = .Document.getElementsByTagName("TD")(2423).innertext
- Sheets("数据表").Cells(m, "K") = .Document.getElementsByTagName("TD")(2425).innertext
- Sheets("数据表").Cells(m, "L") = .Document.getElementsByTagName("TD")(2427).innertext
- Sheets("数据表").Cells(m, "M") = .Document.getElementsByTagName("TD")(2429).innertext
- Sheets("数据表").Cells(m, "N") = .Document.getElementsByTagName("TD")(2431).innertext
- Sheets("数据表").Cells(m, "O") = .Document.getElementsByTagName("TD")(2433).innertext
- Sheets("数据表").Cells(m, "P") = .Document.getElementsByTagName("TD")(2435).innertext
- Sheets("数据表").Cells(m, "Q") = .Document.getElementsByTagName("TD")(2437).innertext
- Sheets("数据表").Cells(m, "R") = .Document.getElementsByTagName("TD")(2439).innertext
- .Quit
-
- End With
- Next
- MsgBox "Complete!" & vbCrLf & "用时:" & " " & Timer - t & "秒"
- End Sub
复制代码
IE大法试试 网页格式不太规律 |
|