I'm trying to save a file with current date and time...I used the code from the following thread:
ActiveWorkbook.SaveAs Filename:="C:FinalOutput.xls " & _
format(Now(), "mm_dd_yyyy hh mm AMPM"), FileFormat:=xlNormal, Password:="", _
WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Now when I try to run the macro, it gives me an error saying: Compile Error, Wrong number of arguments or invalid
property assignment. And it highlights "format" in yellow.
Can someone please help me here?