|
- Option Explicit
- Sub test()
- Dim myPath$, fileName$, st As Worksheet, str
- myPath = ThisWorkbook.Path & ""
- fileName = Dir(myPath)
- Set st = Worksheets("汇总")
- Application.ScreenUpdating = False
- Do While fileName <> ""
- If fileName <> ThisWorkbook.Name Then
- With Workbooks.Open(myPath & fileName)
- str = Split(.Name, ".")(0)
- With ActiveSheet
- .Cells.Find("第一周").Offset(, 1).Resize(1, 4).Copy st.Cells.Find(str).Offset(, 1)
- End With
- .Close
- End With
- End If
- fileName = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|