You can get the date from VBA

Activeworkbook.SaveAs Filename:="Filename" & Format(Date,"mm-dd-yyyy") &
".xls"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"yobrokerboy" wrote in message
...
I'm trying to figure out how I can have a macro save an Excel 2000
Worksheet
and get the name of the worksheet from a cell reference, i.e.
FileNameDATE,
where DATE is the contents of a cell generated as =TODAY() in format
mm-dd-yyyy. For this discussion, the date is in cell A1.

Any and all input is greatly appreciated.