回答：

总有一个适合你。SUb 合并工作簿() dim fileset dim i as integer on error goto 0 application.sCReenupdating = false fileset = application.getopenfilename(filefilter:="Excel 2003(*.xls),*.xls,Excel 2007(*.xlsx),*.xlsx", _ multiselect:=true, title:="选择要合并的文件") if typename(fileset) = "boolean" then goto exitSUb end if For each filename in fileset workbooks.open filename sheets().move after:=thiSWorkbook.sheets(thiSWorkbook.sheets.count) next exitSUb: application.sCReenupdating = true end SUb SUb 汇总工作表() dim sh as worksheet dim destsh as worksheet dim last as long dim shlast as long dim copyrng as range dim startrow as long application.sCReenupdating = false application.enableevents = false '新建一个“汇总”工作表 application.displayalerts = false on error reSUme next activeworkbook.worksheets("汇总").delete on error goto 0 application.displayalerts = true set destsh = activeworkbook.worksheets.add destsh.name = "汇总" '开始复制的行号，忽略表头，无表头请设置成1 startrow = 1 For each sh in activeworkbook.worksheets if sh.name destsh.name then last = lastrow(destsh) shlast = lastrow(sh) if shlast > 0 and shlast >= startrow then set copyrng = sh.range(sh.rows(startrow), sh.rows(shlast)) if last + copyrng.rows.count > destsh.rows.count then msgbox "内容太多放不下啦！" goto exitSUb end if copyrng.copy with destsh.cells(last + 1, "a") .pastespecial xlpastevalues .pastespecial xlpasteFormats application.cutcopymode = false end with end if end if next exitSUb: application.goto destsh.cells(1) destsh.columns.Autofit application.sCReenupdating = true application.enableevents = true end SUb