save file with current date

[spq24]

Hello

I am trying to save the file with a value from a cell followed by the current date

example: filename 5-26-2011

Here's the code I have:

ActiveWorkbook.SaveAs Filename:=Range("O29").Value & Format(Now(), "mm-dd-yyyy")

When I do that an error pops up:
Compile error:

Wrong number of arguments or invalid property assignment

can anyone help?

 

[Jonmo1]

forget about saving the file right now...
let's figure out why Format(date...) isn't working...

does this work?

Sub Savefile()
msgbox Format(Date, "mm-dd-yyyy")
End Sub


If this doesn't work, then there is something somewhere..some function/macro/variable or possibly even a Defined Name that is called Date.


Could also possibly be a missing reference.

From VBA, click Tools - References.
Does anything say "missing"?

 

[Jonmo1]

Actually, could also be a function/macro named "Format"

Which actually seems more likely now that I think about it.

 

[Ruddles]

Why won't you tell us what's in O29?

 

[spq24]

There is something called format...good call...I will try it out and let you guys know if that works

 

[Michael M]

FWIW
Lyns code works fine, and The error mentioned by JonMo is spot on.
That's where I'd be looking,... for a Sub or Function called Format

 

[spq24]

That worked! thanks all for the help