Dear all,
Below single code is working fine for my case but I want to add one more logic so that it save my workbook except the sheet “Maindata” & file name would be “outage_17-04-2018” , I mean before saving the file, keep file name & along with current date.

Sub SaveAs()
ActiveWorkbook.SaveCopyAs "C:\test\outage.XLS"
End Sub