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.

ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & wb.Sheets("Control").Range("C74").Value, xlWorkbookNormal

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.