示例
如图所示,在同一个文件夹下有若干个结构相同的工作簿,其中存储了各个大学外语学院各系的招生人数。现需要对该文件夹下的所有工作簿中的数据汇总,求出所有大学外语学院各系2010年招生的总数。如何用VBA实现?
代码
Option Explicit
Sub 多工作薄汇总()
Dim wbk As Workbook
Dim shtSum As Worksheet
Dim shtData As Worksheet
Dim rowSum As Long
Dim colSum As Long
Dim rowNew As Long
Dim rowData As Long
Dim FileName As String
Dim FilePath As String
Dim Rng As Range
Dim bln As Boolean
Dim index As Long
Set shtSum = Sheets("sheet1")
FilePath = ThisWorkbook.Path & "\分表\"
Application.DisplayAlerts = False
rowNew = 1
colSum = 2
shtSum.Cells.Clear
FileName = Dir(FilePath & "*.xls")
Do While FileName <> ""
colSum = colSum &#