|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Set SHW = Worksheets("搜索")
- Set SH0 = Worksheets("数据")
- Set SH1 = Sheets("结果")
- SH1.Range("A1:Z65536").ClearContents
-
-
-
- Str_coon = "HDR=yes';Data Source =" & ThisWorkbook.FullName '//OFFICE2003,2007 通用
- StrSQL = "SELECT * FROM [" & SH0.Name & "$] WHERE 1=1"
- STR条件 = ""
- For IROW = 2 To SHW.Range("A65536").End(3).Row
- If SHW.Cells(IROW, 1).Value <> "" Then
- If STR条件 <> "" Then
- STR条件 = STR条件 & "+"
- Else
- STR条件 = STR条件 & " AND ("
- End If
- STR条件 = STR条件 & " INSTR(搜索词,'" & SHW.Cells(IROW, 1).Value & "')"
- End If
- Next
- If STR条件 <> "" Then STR条件 = STR条件 & ")=0"
- StrSQL = StrSQL & STR条件
-
- SQLARR = GET_SQL_To_Arr(StrSQL, Str_coon, True)
- SH1.Cells.ClearContents
- SH1.Range("A1").Resize(UBound(SQLARR, 1) + 1, UBound(SQLARR, 2) + 1) = SQLARR
- SH1.Select
复制代码 |
|