我用下面的代码测试了几次,没发现有什么问题。
Dim i As Long
Dim web As New System.Windows.Forms.WebBrowser
For i = 564410245050 To 564410245067 '564410245267
e.Form.Controls("Label1").text= i
web.Navigate("http://k2k.sagawa-exp.co.jp/p/web/okurijosearch.do?okurijtable")
For Each elem As System.Windows.Forms.Htmlelement In elems
If elem.GetAttribute("id") Like "_id46:tb1" Then
Dim e_Info As System.Windows.Forms.HtmlElement = elem.GetElementsByTagName("tbody")(0)
Dim e_Info1 As System.Windows.Forms.HtmlElement = e_Info.GetElementsByTagName("tr")(0).GetElementsByTagName("td")(2)
If e_Info1.InnerText <>"お問い合わせNo.をお確かめ下さい." Then '判断货号存在的时候保存
Tables("表A").AddNew
Tables("表A").Current("第一列") = i
DataTables("表A").Save()
End If
End If
Next
End If
Next
[此贴子已经被作者于2014-4-21 16:36:54编辑过]