Sub 按钮1_Click() Set fso = CreateObject('scripting.filesystemobject') '创建一个文件操作对象,并将这个对象赋值给fso Set sh = ActiveSheet '当前工作表 sh.UsedRange.Offset(1).ClearContents '清空表头下面的所有数据 r = 1 Application.ScreenUpdating = False '关闭屏幕更新 For Each f In fso.getfolder(ThisWorkbook.Path).Files If InStr(f.Name, '汇总') = 0 Then With Workbooks.Open(f) r = r + 1 sh.Cells(r, 1) = .Sheets(1).[d6] sh.Cells(r, 2) = .Sheets(1).[g6] sh.Cells(r, 3) = .Sheets(1).[j6] sh.Cells(r, 4) = .Sheets(1).[k13] .Close False End With End If Next f Application.ScreenUpdating = True'恢复屏幕更新End Sub只要点击汇总按钮,excel会自动汇总所有学生试卷内指定内容到“汇总”工作簿中。