VBA将多个带有密码的excel文件合并为一个
首先创建一个 “合并.xlsm”文件(A到U列),第一行复制标准标题行,然后添加一个activex按钮,添加代码:Private Sub CommandButton1_Click()Application.DisplayAlerts = FalseOn Error Resume Next '容错Dim wk, wb As WorkbookDim fname, pathfile As StringDim i, j As IntegerWith Application.FileDialog
原创
2022-05-17 13:52:04 ·
426 阅读 ·
0 评论