insert date in filename

[Guest]

I keep getting a compiler error with this statement. I am launching it from a
command button on an excel document

ChDir "C:\Documents and Settings\udmstaff\My Documents\Ettline\Price Updates"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\udmstaff\My Documents\Ettline\Price
Updates\Price Update_" & _
Format(Date, "mmddyyyy") & ".xls",
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

 

[Frank Kabel]

Hi
I don't get a compile error. What error do you get exactly?