VBA Macro To Create An Excel File With Same Sheet Name As Workbook Name

[Flupsie]

Hi Alan

Thanks for the help

I need two small changes

1) I need the csv file to be saved to "C:\Journal Templates" -(have amended this in the code)
2) I need the sheet name to be the same as the xlsm workbook i.e "JNL"


I have attached my sample workbook

It would be appreciated if you could make the necessary change