按归之前的例子,自己修改了下,可是保存不过来,还会出现假死现象,只能重新启动狐表。
代码如下,请帮助检查下:
Dim web As New System.Windows.Forms.WebBrowser()
web.Navigate("http://cx.jljsw.com:8088/JLJGPublish/corpinfo/CorpInfo.aspx/")
Do Until web.ReadyState = 6
Application.DoEvents
Loop
'取数据
Dim Cols() As String = { "序号","企业名称","组织机构代码","所在市州","法定代表人","资质类型" }
Dim elems As object = web.Document.GetElementById("list_elem").GetElementsByTagName("tr")
Dim m As Integer = 0
For Each elem As object In elems
Dim i As Integer = -1
m = m + 1
If m > 1 Then '因为网页的表格有标题,如果不判断,就会增加出一个空行
Tables("企业列表").AddNew
End If
Dim tdelems As object = elem.GetElementsByTagName("td")
For Each tdelem As object In tdelems
i = i + 1
Tables("企业列表").Current(Cols(i)) = tdelem.Innertext
Tables("企业列表").Current("录入日期") = Date.Today
Next
Next
Tables("企业列表").save