반응형
Sub 시트저장()
Dim Sht As Worksheet
Dim strPath As String
Application.ScreenUpdating = False
strPath = ThisWorkbook.Path & "\"
For Each Sht In Worksheets
With Sht
.Copy
ChDir strPath
ActiveWorkbook.SaveAs Filename:=strPath & Sht.Name & ".xlsx"
ActiveWindow.Close
End With
Next Sht
End Sub
댓글