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

[Ravana]

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.

[davesexcel]

Probably,

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

[Ravisca2003]

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]

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.

Please supply your answer and not a link to the possible answer.

[Ravana]

@Davesexcel

Thanks for the snippet.

Cheers!