Sub 分檔()
Application.ScreenUpdating = False
Dim folder As String
folder = ThisWorkbook.Path & "\各部門清冊"
If Len(Dir(folder, vbDirectory)) = 0 Then MkDir folder
Dim sht As Worksheet
For Each sht In Worksheets
sht.Copy
ActiveWorkbook.SaveAs folder & "\" & sht.Name & ".xlsx"
ActiveWorkbook.Close
Next
Application.ScreenUpdating = True
End Sub
歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/) |