Have current date display in File Name

[ploddinggaltn]

I use this code to save my file as Payable with the current date. I would
like the date to display first and I just can't seem to get it to work, how
do I code the date to display first in the file name. Thanks


ActiveWorkbook.SaveAs Filename:= _
"C:\Payable\Payable " & _
Format(Now, "MM-DD-YYYY") & ".xls", _
FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

 

[darrenmcconachie]

Is this what you're after...

ActiveWorkbook.SaveAs Filename:= _
"C:\Payable\" & Format(Now, "MM-DD-YYYY") & " Payable.xls", _
FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Regards
Darren