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
Bookmarks