excel多工作表合并成一个工作表
按【Alt】+【F11】
然后找到工具栏上面的“运行”下的“运行子过程/用户窗体”
sub 合并当前目录下所有工作簿的全部工作表()
dim mypath, myname, awbname
dim wb as workbook, wbn as string
dim g as long
dim num as long
dim box as string
application.screenupdating = false
mypath = activeworkbook.pa...
转载
2020-08-27 16:39:07 ·
187 阅读 ·
0 评论