|
- Sub Macro1()
- Dim wb As Workbook, mypath$, wj$, s&
- mypath = ThisWorkbook.Path & ""
- wj = Dir(mypath & "*.xls")
- Application.ScreenUpdating = False
- ActiveSheet.UsedRange.Clear
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- s = s + 1
- Set wb = GetObject(mypath & wj)
- wb.Sheets(1).Cells(2, 1).Resize(1, 27).Copy Cells(s, 1)
- wb.Close 0
- End If
- wj = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|