想通過vba點擊http://www.dce.com.cn/dalianshangpin/xqsj/tjsj26/rtj/rcjccpm/index.html網頁中的“批量下載”,用于選擇日期。代碼怎么寫?
我自己寫了代碼,哪里錯了?
Set IE = CreateObject("internetexplorer.application")
strurl = "http://www.dce.com.cn/dalianshangpin/xqsj/tjsj26/rtj/rcjccpm/index.html"
IE.navigate strurl
IE.Visible = False
Do While IE.READYSTATE <> 4
DoEvents
Loop
Set aa = IE.document.getelementsbytagname("a")
For Each b In aa
If Trim(b.innertext) = "批量下載" Then
b.Click
Exit For
End If
Next
uj5u.com熱心網友回復:
你得獲取日期元素,修改其值,重繪頁面,再點擊下載。轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/16838.html
標籤:VBA
