Excel Workbook save except one sheet by macro

[nur2544]

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.

Please Login or Register  to view this content.

[Kaper]

Try:

Please Login or Register  to view this content.

[nur2544]

Hi Kaper, Great ! , Yes it works perfectly , thanks for your time in this regard.