|
- Sub grf()
- Dim sh As Worksheet, wb As Workbook
- Set fso = CreateObject("scripting.filesystemobject")
- Set ff = fso.getfolder(ThisWorkbook.Path)
- Dim arr(1 To 100000, 1 To 100)
- For Each fff In ff.subfolders
- For Each f In fff.Files
- frr = Split(f, "")
- x = frr(UBound(frr) - 1) & "-" & frr(UBound(frr)) '文件夹名-工作表名
- Set wb = Workbooks.Open(f)
- For Each sh In wb.Worksheets
- If sh.UsedRange.Cells.Count > 1 Then
- brr = sh.UsedRange
- For i = 1 To UBound(brr)
- n = n + 1
- For j = 1 To UBound(brr, 2)
- arr(n, j) = brr(i, j)
- Next
- arr(n, j) = x
- Next
- End If
- Next
- wb.Close False
- Next
- Next
- If n > 0 Then [a1].Resize(n, j) = arr
- End Sub
复制代码 |
|