|
如何汇总文件夹中所有工作簿固定行到新建工作簿,从第12行开始,往后移动6行,一直到没有内容为止
没调输出格式,自己搞定吧。 - Sub 导入文件()
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- Dim arr(1 To 10000, 1 To 10)
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- Set Sht = wb.Worksheets(1)
- For i = 1 To Sht.[a65536].End(3).Row
- If Sht.Cells(i, 1) = "客户品名" And Len(Sht.Cells(i, 1)) Then
- n = n + 1
- arr(n, 1) = Filename
- For j = 1 To 9
- arr(n, j + 1) = Sht.Cells(i + 1, j)
- Next
- End If
- Next
- wb.Close False
- End If
- Filename = Dir
- Loop
- Set Sht = Nothing
- For i = UBound(arr) To 2 Step -1
- If arr(i, 1) = arr(i - 1, 1) Then arr(i, 1) = ""
- Next
- [a1].Resize(n, 10) = arr
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|