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