Sub Macro1()
For i = 1 To ActiveWorkbook.Sheets.Count
ActiveWorkbook.Sheets(i).Select
Activesheet.Copy
ActiveWorkbook.SaveAs Replace(Range("A1").Value, "/", "-") & "-" & Range("A2").Value, _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
Next i
End Sub
To change the path:
Record yourself saving a file to your required folder and modify the above line to refer to that folder:
ActiveWorkbook.SaveAs Replace(Range("A1").Value, "/", "-") & "-" & Range("A2").Value, _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Becomes:-
ActiveWorkbook.SaveAs "C:\Users\*********\Desktop\Documents\" & Replace(Range("A1").Value, "/", "-") & "-" & Range("A2").Value, _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Bookmarks