Changing Cell Value format as desired while saving the file in the current directory

Hi all,

I am using below code to save the active workbook in the current directory using cell value C74 as the name of the workbook.

Please Login or Register  to view this content.

Value in C74 is stored in the format dd-mm-yyyy.While saving the file name it is saving as dd-mm-yyyy but I would like to save the file name in the format "MMM YYYY" .

Any help will be appreciated.

https://powerspreadsheets.com/vba-fo...ing-VBA-mmm-yy

refer this for guidance. You may either while selecting the range, chnge the format of date internally.

@Davesexcel

Thanks for the snippet.

Cheers!