Sub fencun() Application.ScreenUpdating = False b = Sheets.Count For i = 1 To b Sheets(i).Copy a = ThisWorkbook.Worksheets(i).Name With ActiveWorkbook .SaveAs Filename:=ThisWorkbook.Path & "\" & a & ".xls" .Close End With Next i Application.ScreenUpdating = true End Sub
Sub 宏1() For Each st In Sheets st.Copy ActiveWorkBook.SaveAs st.Name ActiveWorkBook.Close '如果保存后不关闭就删除此行 Next st End Sub本回答被提问者采纳
第2个回答 2017-09-05
右键,会有菜单出来,选择移动或复制工作表
追问
谢谢,原来这么简单....工作簿不能合并的吧
第3个回答 2017-09-05
这个用代码一键来完成。在你的工作簿vbe窗口,新建一个模块,将以下代码复制进去,然后点击运行,就可以实现工作簿的拆分。 Sub 拆分到工作簿() Dim wk As Workbook, ss$, k% Application.DisplayAlerts = False For Each sht In Worksheets Set wk = Workbooks.Add k = k + 1 Workbooks(1).Sheets(k).Copy Workbooks(2).Sheets(1) ss = ThisWorkbook.Path & "\" & sht.Name & ".xlsx" wk.SaveAs ss wk.Close Next Application.DisplayAlerts = True MsgBox "拆分工作簿完成!" End Sub