1)把以下这段代码复制到个人宏工作簿的模块里准备调用
Sub MoveSheets()
Dim w As Workbook, ws As Workbook, sht As Worksheet, I As Integer
Set w = Workbooks("源文件名")
Set ws = Workbooks("目标文件名")
For Each sht In w.Worksheets
I = ws.Worksheets.Count
sht.Move after:=ws.Sheets(I)
Next
End Sub
2)打开这两个文件,再执行这个宏
追问谢谢,成功了