|
附件consol中有5个excel表,格式一模一样,请各位大神帮忙写一个程序,能够实现China的数据是Beijing,Shanghai,Tianjin, Guangzhou对应单元格的加总。不想要一个一个的加,因为实际中我有10个excel表,而且每一张表的内容特别多,想学习一下如何用代码实现这个加总。比较急,谢谢谢谢!
- Sub 导入文件()
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- [c4:aj58].ClearContents
- res = [c4:aj58]
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- Set Sht = wb.Worksheets(1)
- arr = Sht.[c4:aj58]
- wb.Close False
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) <> 0 Then res(i, j) = res(i, j) + arr(i, j)
- Next
- Next
- End If
- Filename = Dir
- Loop
- Set Sht = Nothing
- [c4:aj58] = res
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|