[VBA ]请教 VBA 连接 IE 抓取资料

楼主: qaz0955qaz (qaz0955qaz)   2021-06-30 00:55:05
请教一下,底下的VBA 程式码如何抓取网页中的资讯如下
"统一编号:22099131, 登记机关:科技部新竹科学园区管理局 , 登记现况:核准设立
, 地址:新竹科学园区新竹市力行六路8号 , 资料种类:公司 , 核准设立日期:
0760221, 核准变更日期:1100625"
Sub test()
Dim oIE As Object, oNode As Object
Set oIE = CreateObject("InternetExplorer.Application")
With oIE
.Visible = True
.Navigate "https://findbiz.nat.gov.tw/fts/query/QueryBar/queryInit.do"
Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
.document.all("qryCond").Value = "台湾积体电路"
.document.getElementById("qryBtn").Click
Application.Wait Now + TimeValue("00:00:05")
End With
End Sub
谢谢
作者: waiter337 (给开司一罐苏格登)   2021-07-04 14:27:00
wait now 那段改成Do While .Busy Or .ReadyState <> 4: DoEvents: Loop然后Text = oIE.Document.getElementById("vParagraph").innertext然后就到end with了然后 oIE.Quitset oIE = NothingEND SUB

Links booklink

Contact Us: admin [ a t ] ucptt.com