Sub 工作簿拆分()
'将EXCEL工作簿按工作表拆分为工作簿
Dim PATH As String
PATH = Application.ActiveWorkbook.PATH
Dim sht As Worksheet
Application.ScreenUpdating = False
For Each sht In Sheets
sht.Copy
ActiveWorkbook.SaveAs PATH & "\" & sht.Name & ".xlsx" '(工作表名称文件名)
ActiveWorkbook.Close
Next
Application.ScreenUpdating = True
End Sub
Sub UnhideAllSheets()
For Each Sheet In ActiveWorkbook.Sheets
Sheet.Visible = True
Next
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
本文来源:https://www.wddqw.com/doc/a0ac23a8adaad1f34693daef5ef7ba0d4a736d94.html
正在阅读:
VBA EXCEL拆分工作表为工作薄01-01
一的成语01-01
小学法制手抄报的名言01-01
看老城变化 读厚重新安作文 600多字 散文写历史01-01
诸葛亮来我家01-01
大约喝了几两红酒会怎么样01-01
语文初二上人教新资料第16课(大自然的语言)拓展资料(5篇)01-01
十一国庆节的黑板报:国庆节01-01
诱组词100个01-01