Adding date to file save as

[Dylan&Hayden]

I'm using VBA to change some formating in a worksheet and I need to save the file as a different name with today's date - preferably in month only format:

ActiveWorkbook.SaveAs Filename:="T:\GENERAL\XAA.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

How can I add in the date in month format so the file created will be titled:
XAA - June.xls (Using today's date as the file creation date)

[mrice]

Why not use a function like this

Please Login or Register  to view this content.

I'll leave you to fill in the rest

Please Login or Register  to view this content.

[Dylan&Hayden]

Got it!

Thanks mrice