Sub 宏1()
Dim sh As Worksheet
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sh In Worksheets
sh.Copy
ActiveWorkbook.Close True, ThisWorkbook.Path & "\" & sh.Name & ".xlsx"
Next
End Sub
Sub 宏2()
Dim sh As Worksheet
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sh In Worksheets
sh.Copy
ActiveWorkbook.Close True, ActiveWorkbook.Path & "\" & sh.Name & ".xlsx"
Next
End Sub
宏2产生的路径是刚复制的工作簿路径,那是没有路径的,用以下语句可以验证:
Sub 宏2()
......
For Each sh In Worksheets
sh.Copy
abc = ActiveWorkbook.Path & "\"
ActiveWorkbook.Close True, ActiveWorkbook.Path & "\" & sh.Name & ".xlsx"
Next
End Sub
宏2产生的路径是刚复制的工作簿路径,那是没有路径的,用以下语句可以验证:
Sub 宏2()
......
For Each sh In Worksheets
sh.Copy
abc = ActiveWorkbook.Path & "\"
ActiveWorkbook.Close True, ActiveWorkbook.Path & "\" & sh.Name & ".xlsx"
Next
End Sub