excel
1、新建个文件夹，把要合并的表格都扔进去，然后再新建一个
excel表格 2、右键点击底部的Sheet1，选择查看代码（注意：这个功能
excel有，WPS好像没有） 3、然后把下面这段代码复制进去： Sub 合并当前目录下所有工作簿的全部工作表()Dim MyPath, MyName, AWbNameDim Wb As workbook, WbN As StringDim G As LongDim Num As LongDim BOX As String*.screenupdating = FalseMyPath = *.pathMyName = Dir(MyPath & & *.xls)AWbName = *.nameNum = 0Do While MyName If MyName AWbName ThenSet Wb = *.open(MyPath & & MyName)Num = Num + 1With Workbooks(1).ActiveSheet.Cells(.Range(B65536).End(xlUp).Row + 2, 1) = Left(MyName, Len(MyName) - 4)For G = 1 To *.count*.sheets(G).*.copy .Cells(.Range(B65536).End(xlUp).Row + 1, 1)NextWbN = WbN & Chr(13) & *.name*.close FalseEnd WithEnd IfMyName = DirLoopRange(B1).Select*.screenupdating = TrueMsgBox 共合并了 & Num & 个工作薄下的全部工作表。如下： & Chr(13) & WbN, vbInformation, 提示End Sub4、点一下运行，然后等一会（表格多的话会有点久），搞定
