|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Private Sub CommandButton1_Click()
- Dim ARR, SQL$, RST As Object, temp$
- ARR = [B2:H3]
- For i = 1 To 7
- If ARR(2, i) > "" Then temp = temp & " AND " & ARR(1, i) & " like '%" & ARR(2, i) & "%'"
- Next
- SQL = "SELECT " & Join([transpose(transpose(b5:i5))], ",") & " FROM [物料记录] "
- If Len(temp) Then SQL = SQL & " WHERE " & Mid(temp, 5)
- [B6:I65536] = ""
- With CreateObject("adodb.connection")
- .Open "Provider=Microsoft.Ace.OLEDB.12.0;data source=" & ThisWorkbook.Path & "\物料记录.mdb"
- Set RST = .Execute(SQL)
- If Not RST.EOF Then [B6].CopyFromRecordset RST
- .Close
- End With
- MsgBox "ok"
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|