Excel VBA 抓取下拉式選單網頁資料,執行程式時網頁內容為何沒同時觸發更動??

Excel VBA 抓取下拉式選單網頁資料,執行程式時Show entries(顯示多少項目)已選到100,但網頁內容為何沒同時觸發更動??
求解,謝謝~



Sub test()

x = Timer

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

u = "https://www.gurufocus.com/dividend/awr"

IE.navigate u
IE.Visible = True


Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE

With IE
.document.getElementsByName("history_length")(0).selectedIndex = 3

Do While .readyState <> 4 Or .Busy
DoEvents
Loop
End With

Application.Wait (Now + TimeValue("0:00:03"))
Dim doc As HTMLDocument
Set doc = IE.document
On Error Resume Next

For i = 0 To 30
Worksheets("I").Range("I" & i + 3) = doc.getElementsByClassName("R10 dataTable")(0).getElementsByTagName("td")(i * 6 + 1).innerText
Next i

'IE.Quit '關畢ie
End Sub
2017-10-31 17:24 發佈
內文搜尋
X
評分
評分
複製連結
Mobile01提醒您
您目前瀏覽的是行動版網頁
是否切換到電腦版網頁呢?