| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 870 人关注过本帖
标题:请问:怎么修正:实时错误91,“对象变量或with变量未设置”(黄色标向:Se ...
取消只看楼主 加入收藏
dq8888
Rank: 1
等 级:新手上路
帖 子:15
专家分:5
注 册:2015-5-29
结帖率:100%
收藏
已结贴  问题点数:10 回复次数:0 
请问:怎么修正:实时错误91,“对象变量或with变量未设置”(黄色标向:Set lrow = table.rows(0))
这是获取webbrowser控件网页的表格内容导入数据表中,运行出现:实时错误91,“对象变量或with变量未设置”

Private Sub Command1_Click()
    WebBrowser1.navigate "http://www.

End Sub

Private Sub Form_Load()
    WebBrowser1.Stop
End Sub

Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
    Dim doc As MSHTML.HTMLDocument
    Set doc = WebBrowser1.document
    Dim table As MSHTML.HTMLTable
    Dim lrow As MSHTML.HTMLTableRow
    Dim cel As MSHTML.HTMLTableCell
    Set table = doc.getElementById("REPORTID_tab1")
    Dim Conn As ADODB.Connection
   
    Dim FLD() As String
    Set Conn = CreateObject("ADODB.Connection")
   
    Conn.Open "provider=microsoft.jet.oledb.4.0;data source=d:\DB1.MDB"
    Set lrow = table.rows(0)
    ReDim FLD(0 To lrow.cells.length) As String
    Dim i As Integer
    Dim tbname As String
    Dim sql As String
    tbname = InputBox("表1", "table1")
    For i = 0 To lrow.cells.length - 1
        FLD(i) = Replace(Replace(Replace(lrow.cells(i).innerText, "/", ""), "(", ""), ")", "")
        sql = sql & FLD(i) & " varchar(255),"
    Next i
    sql = Left(sql, Len(sql) - 1)
    Conn.Execute "create table " & tbname & " (" & sql & ")"
    Dim j As Integer
    sql = ""
    For i = 0 To lrow.cells.length - 1
        sql = sql & FLD(i) & ","
    Next i
    sql = Left(sql, Len(sql) - 1)
    Dim vlist As String
    For i = 1 To table.rows.length - 1
        vlist = ""
        Set lrow = table.rows(i)
        For j = 0 To lrow.cells.length - 1
            vlist = vlist & "'" & lrow.cells(j).innerText & "',"
        Next j
        vlist = Left(vlist, Len(vlist) - 1)
        Conn.Execute "insert into " & tbname & " (" & sql & ") values (" & vlist & ")"
    Next i
   
    Conn.Close

    Set Conn = Nothing
End Sub
搜索更多相关主题的帖子: Object 数据表 黄色 网页 
2015-06-01 16:15
快速回复:请问:怎么修正:实时错误91,“对象变量或with变量未设置”(黄色标向 ...
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.029810 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved