拆分excel工作薄里的多个工作表为多个工作薄

Sub SaveSeparately()

Dim sht As Worksheet

Application.ScreenUpdating = False

ipath = ThisWorkbook.Path & “\”

For Each sht In Sheets

sht.Copy

ActiveWorkbook.SaveAs ipath & sht.Name & “.xls”

ActiveWorkbook.Close

Next

Application.ScreenUpdating = True

End Sub

本文是全系列中第8 / 9篇:Excel
上一篇 按列将一个Excel工作表的数据拆分成多个工作表
下一篇 批量导入硬盘中的图片文件名称到Excel