Excel 2013 VBA - Saving a file as today's date formatted as January_30_2018.xlsm

I would like to save my current excel workbook as the current date. However, I would like to have the date formatted so that the entire month is written out followed by the day followed by the year.
I know that colons are not allowed in file names so I'm okay with underscores.
Example: January_30_2018.xlsm
Who is Participating?
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
This will save as a macro enabled workbook

ThisWorkbook.SaveAs Filename:="enter path here" & "\" & Format(Date, "mmmm_dd_yyyy"), _
        FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

Open in new window

Roy CoxGroup Finance ManagerCommented:
Pleased to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.