|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
工作簿1.7z
(267.69 KB, 下载次数: 1)
报错说 至少一个参数没有被指定值,求解
Sub record3筛选()
Dim strconn As String
Dim strsql As String
Dim today$, endday$
today = Format(Sheets("data").[m1], "yyyy-mm-dd")
endday = Format(Sheets("data").[m1].Offset(0, -9).Value, "yyyy-mm-dd")
Set adoconn = CreateObject("ADODB.Connection") '后期绑定
strconn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _
ThisWorkbook.Path & "\" & ActiveWorkbook.Name & ";Extended Properties=""Excel 12.0;HDR=YES"";"
strsql = "select * from data where ([" & today & " ]- [" & endday & "])/[" & endday & "] >0.3"
adoconn.Open strconn
Sheets("record3").Range("a1").CopyFromRecordset adoconn.Execute(strsql)
adoconn.Close
End Sub
|
|