|
- Sub 按钮1_Click()
- Set fso = CreateObject("scripting.filesystemobject")
- Set sh = ActiveSheet
- Application.ScreenUpdating = False
- sh.UsedRange.Offset(1).ClearContents
- For Each f In fso.getfolder(ThisWorkbook.Path).Files
- If LCase(Right(f.Name, "4")) = ".csv" Then
- With Workbooks.Open(f)
-
- ActiveSheet.UsedRange.Offset(5).Copy sh.Cells(Rows.Count, 2).End(3).Offset(1)
- .Close False
- End With
- r1 = sh.Cells(Rows.Count, 1).End(3).Row + 1
- r2 = sh.Cells(Rows.Count, 2).End(3).Row
- If r2 > r1 Then sh.Cells(r1, 1).Resize(r2 - r1 + 1).Value = f.Name
- End If
- Next f
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|