|
发表于 2014-9-29 10:54
|
显示全部楼层
本楼为最佳答案
- Sub 导入文件()
- Application.ScreenUpdating = False
- Dim filename, wb As Workbook, Sht As Worksheet, Sh As Worksheet, xRng As Range
- filename = Dir(ThisWorkbook.Path & "\*.xls")
- Dim arr(1 To 1000, 1 To 4)
- Set Sh = Sheet1
- Do While filename <> ""
- If filename <> ThisWorkbook.Name Then
- n = n + 1
- fn = ThisWorkbook.Path & "" & filename
- Set wb = Workbooks.Open(fn)
- Set Sht = wb.Worksheets("事(总表)")
- If n = 1 Then
- Sh.[c1].Resize(1, 67).Value = Application.Transpose(Sht.[c7:c73])
- Sh.Cells(1, 70).Resize(1, 68) = Application.Transpose(Sht.[L6:L73])
- End If
- r = Sh.[a65536].End(3).Row + 1
- Sh.Cells(r, 1) = Val(Mid(filename, 2))
- Sh.Cells(r, 2) = Trim(Mid(Sht.[a3], 6))
- Sh.Cells(r, 3).Resize(1, 67).Value = Application.Transpose(Sht.[g7:g73])
- Sh.Cells(r, 70).Resize(1, 68) = Application.Transpose(Sht.[p6:p73])
- wb.Close False
- End If
- filename = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|