|
- Sub 合并工作簿()
- Dim 文件名, 路径 As String
- Dim WB As Workbook
- Dim SHT As Worksheet
- Dim I As Integer
- 路径 = InputBox("请输入路径")
- If 路径 = "" Or IsNumeric(路径) = True Then
- Exit Sub
- End If
- 文件名 = Dir(路径 & "" & "*.xls*")
- For I = 1 To 1000
- Set WB = Workbooks.Open(路径 & "" & 文件名) '打开工作簿
- '导入工作簿
- For Each SHT In WB.Sheets
- SHT.Copy AFTER:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
- ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count).Name = SHT.Name
- Next
- WB.Close '关闭工作簿
- 文件名 = Dir
- If 文件名 = "" Then
- Exit For
- End If
- Next
- Sheet1.Select
- End Sub
复制代码 上面的代码在工作簿里运行没问题,但加载宏后就出错。
原因是.xlam文件和当前工作簿都有一个THISWORKBOOK,请问如何解决?
十分感谢。
|
|