|
此宏以前运行正确,前天运行时出现错误,在其他电脑上运行正常,不知什么原因?请老师指点!!谢谢!!
microsoft activex data objects 2.8 library 已引用
Sub 查询()
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
Set cnn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
cnn.Open "Provider=Microsoft.Jet.OleDb.4.0;Extended Properties='Excel 8.0; HDR=yes';Data Source=" & ThisWorkbook.FullName
'运行到此句时出现以下提示
运行时错误 '3706':未找到提供程序。该程序可能未正确安装。
sql = "Select 商品名称 , sum(单价) FROM [数据库$d5:j13] Where 颜色 like '%黑%'GROUP BY 商品名称 "
rs.Open sql, cnn, adOpenStatic
Sheet6.Range("a2").CopyFromRecordset rs
rs.Close
cnn.Close
Set rs = Nothing
Set cnn = Nothing
End Sub |
评分
-
1
查看全部评分
-
|