Sub aa() Dim i As String Dim x As Integer For x = 1 To Sheets.Count i = Sheets(x).Name Sheets(x).Copy ActiveWorkbook.SaveAs ThisWorkbook.Path & "/" & i & ".xls" ActiveWorkbook.Close Next x End Sub
Sub aa() Dim i As String Dim x As Integer For x = 1 To Sheets.Count i = Sheets(x).Name Sheets(x).Copy ActiveWorkbook.SaveAs ThisWorkbook.Path & "/" & i & ".xls" ActiveWorkbook.Close Next x End Sub