|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 iwangyi 于 2020-2-13 11:42 编辑
Sub C()
Set CN = CreateObject("ADODB.CONNECTION")
CN.Open "provider=microsoft.ace.oledb.12.0;extended properties=excel 12.0;data source=" & ThisWorkbook.FullName
For I = 9 To 15
If Cells(2, I) <> "" Then
s = s & Cells(1, I) & " like '%" & Cells(2, I) & "%' and "
End If
Next
If s = "" Then
Sql = "select * from [明细$A2:G]"
Else
s = Left(s, Len(s) - 4)
Sql = "select * from [明细$A2:G] where " & s
End If
Range("I5").CopyFromRecordset CN.Execute(Sql)
End Sub
|
评分
-
1
查看全部评分
-
|