Sub lqxs()
Dim ar, i&, wb As Workbook, r&
Dim rng As Range, br()
p = ThisWorkbook.Path & "\"
f = Dir(p & "B.xls*")
If f = "" Then MsgBox "找不到数据源文件!": Exit Sub
Set rng = Sheet1.Columns(3).Find(Date, , , , , , 1)
If Not rng Is Nothing Then MsgBox "不要重复拷贝!": Exit Sub
Set wb = Workbooks.Open(p & f)
ar = wb.Sheets(1).[c1].CurrentRegion
ReDim br(1 To UBound(ar), 1 To UBound(ar, 2))
wb.Close False
For i = 2 To UBound(ar)
If ar(i, 1) = Date Then
n = n + 1
For j = 1 To UBound(ar, 2)
br(n, j) = ar(i, j)
Next j
End If
Next i
If n = "" Then MsgBox "数据源文件没有今天的数据!": Exit Sub
r = Cells(Rows.Count, 3).End(xlUp).Row + 1
Cells(r, 3).Resize(n, UBound(br, 2)) = br
MsgBox "本次提取了" & n & "行数据"
Application.ScreenUpdating = True
End Sub
|