Try...
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\username\My
Documents\" & Format(Now() - 1, "yymmdd") & ".xls"

Frank

"sd" wrote:

Can I save a file named ( yesterdays date ) using a macro.