|
- Sub 汇总()
- Dim strFileName As String, xlApp, xlBook, xlSheet
- Dim i As Integer, arr, temp(1 To 28, 1 To 10), j As Integer, k As Integer, arrTemp
- Dim arr2(1 To 3) As Variant
- For i = 1 To UBound(arr2)
- arr2(i) = temp
- Next
- strFileName = Dir(ActiveWorkbook.Path & "")
- Set xlApp = CreateObject("Excel.Application")
- Application.ScreenUpdating = False
- Do While strFileName <> ""
- If strFileName <> ThisWorkbook.Name And InStr(strFileName, ".xls") > 0 Then
- Set xlBook = xlApp.Workbooks.Open(ActiveWorkbook.Path & "" & strFileName)
- Set xlSheet = xlBook.Worksheets
- For i = 1 To xlSheet.Count
- arr = xlSheet(i).Range("d6:m33")
- arrTemp = arr2(i)
- For j = 1 To 28
- For k = 1 To 10
- arrTemp(j, k) = arrTemp(j, k) + arr(j, k)
- Next
- Next
- arr2(i) = arrTemp
- Next
- xlApp.DisplayAlerts = False
- xlBook.Close
- End If
- strFileName = Dir
- Loop
- xlApp.Quit
- For i = 1 To UBound(arr2)
- Sheets(i).Range("d6:m33") = arr2(i)
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|