Not too sure but have you tried it without the () , i.e. ActiveWorkbook.SaveAs
Filename:="C:\" & Format(Now, mmddyy) & ".xls"
It is just a thought because part of one of my vba run sheets creates a filename
for the saved workbook from various cells but then also includes the date  and
time in the filename and my bit of code does not have the () after now