|
本帖最后由 jk0932 于 2017-2-21 15:28 编辑
有若干个表,每个工作簿都有一个Sheet名称为XX,现在需要提取各个工作簿中Sheet名为XX的E8~F9 4 个单元格的数据,放入到汇总表;最终汇总到成4行数据
最佳答案很厉害
- Sub 导入文件()
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet, sh As Worksheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- Set sh = ActiveSheet
- j = 1
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- Set Sht = wb.Worksheets("XX")
- j = j + 1: sh.Cells(1, j) = Split(Filename, ".")(0)
- For i = 2 To 5
- ad = sh.Cells(i, 1)
- sh.Cells(i, j) = Sht.Range(ad)
- Next
- wb.Close False
- End If
- Filename = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|