Hi

I have work book with 8 sheets in it ,once I run macro it will create a report with 6 work sheets.

What I want is after report generation it should save the report at desired server location with today’s date .

Example:

\\server\\xyz\NGE report as on 15th Apr 2017.xls

Here: \\server\\xyz\ is server path and

NGE report as on 15th Apr 2017.xls is the file name