current work sheet should save as new work book with current sheet name.

[husayn]

Hi

My sheet name is 2018, i want to save my work sheet as new work book with name 2018 in csv extention.

Kindly help

 

[JackDanIce]

Where should the worksheet be saved? Record a macro to do this, post the resulting code back.

Search engine: "VBA Save sheet as CSV"
https://www.google.co.uk/search?q=v.....69i57j0l5.3579j0j7&sourceid=chrome&ie=UTF-8

First search suggestion: https://stackoverflow.com/questions/34155718/vba-saving-single-sheet-as-csv-not-whole-workbook

Try to adapt that code

 

[husayn]

Thanks for your reply Jack

i am still confused i am unable to do this

my system path is "C:\Users\405263\Desktop\gg"

need your more help to finish this & i want to save only one sheet not the workbook.