|
发表于 2011-9-22 17:28
|
显示全部楼层
本楼为最佳答案
- Sub justtest()
- Dim Arr(1 To 60000, 1 To 100), Si As Byte, Ei As Byte, Ar
- Dim Wb As Workbook, i&, p$, X$, A1 As Byte, A2&, j As Byte, G&
- Application.ScreenUpdating = False
- Si = [c1].Value: Ei = [d1].Value
- p = ThisWorkbook.Path & "\数据文件"
- X = Dir(p & "*.xlsx")
- If X <> "" Then
- Do
- A1 = A1 + 1
- Set Wb = GetObject(p & X)
- With Wb
- With .Sheets(1)
- Ar = .Range("A1").CurrentRegion.Value
- For i = 3 To UBound(Ar, 1) - 3
- If Ar(i, 1) = Si And Ar(i + 1, 1) = Ei Then
- For j = 1 To 6
- A2 = A2 + 1
- Arr(A2, A1) = Ar(i - 3 + j, 1)
- Next j
- A2 = A2 + 1
- End If
- Next i
- End With
- .Close False
- End With
- X = Dir: G = G + A2: A2 = 0
- Loop Until X = ""
- End If
- Range("K1").Resize(Rows.Count, Columns.Count - 10).Clear
- With Range("k1").Resize(G, A1)
- .Value = Arr
- Application.ScreenUpdating = True
- MsgBox "处理成功,请看生成区域结果:" & .Address(0, 0)
- End With
- End Sub
复制代码
如何实现指定条件批量查询?.rar
(249.96 KB, 下载次数: 64)
|
|