同一个文件夹excel合并,以及同一个文件夹下特定sheet合并代码
合并sheet1:Sub 合并当前目录下所有工作簿的全部工作表()Dim MyPath, MyName, AWbNameDim Wb As Workbook, WbN As StringDim G As LongDim Num As LongDim BOX As StringApplication.ScreenUpdating = FalseMyPath = ActiveWork...
原创
2019-04-19 09:29:05 ·
2136 阅读 ·
0 评论