|
- Sub tt()
- Dim ws As Workbook, sht As Worksheet, path, str, i&, d
- Application.ScreenUpdating = False
- Set sht = ActiveSheet
- path = ThisWorkbook.path & ""
- d = Dir(path & "*.xls")
- Do While d <> ""
- If d <> ThisWorkbook.Name Then
- Set ws = Workbooks.Open(path & d)
- i = sht.Cells(Rows.Count, 1).End(3).Row + 1
- With ws.Sheets(1)
- sht.Cells(i, 1) = Replace(.[a1], "填报单位:", "")
- .Cells(Rows.Count, 1).End(3).Offset(0, 1).Resize(1, 8).Copy
- sht.Cells(i, 3).PasteSpecial (xlPasteValues)
- End With
- ws.Close False
- End If
- d = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|