|
Sub test()
Dim myPath$, AK As Workbook, OAK As Workbook
Set fso = CreateObject("Scripting.FileSystemObject")
Set OAK = ActiveWorkbook
Set FD = fso.GetFolder(ThisWorkbook.Path)
Application.ScreenUpdating = False '冻结屏幕,以防屏幕抖动
OAK.Sheets(1).Range("a3:g65536").ClearContents
For Each f In FD.Files
If InStr(f.Name, OAK.Name) = 0 Then
Set AK = Workbooks.Open(f.Path, True)
For i = 1 To AK.Sheets.Count
With AK.Sheets(i)
.Range("l7").Copy OAK.Sheets(1).Cells(i + 2, "a")
.Range("c6").Copy OAK.Sheets(1).Cells(i + 2, "b")
.Range("l6").Copy OAK.Sheets(1).Cells(i + 2, "c")
.Range("a10").Copy OAK.Sheets(1).Cells(i + 2, "d")
.Range("h10").Copy OAK.Sheets(1).Cells(i + 2, "e")
.Range("j10").Copy OAK.Sheets(1).Cells(i + 2, "f")
.Range("l10").Copy OAK.Sheets(1).Cells(i + 2, "g")
End With
Next i
AK.Close False
End If
Next
End Sub
|
|