You have to be careful not to use \ in a filename, so you cannot use the
cell Text property. Format the date yourself, in reverse order for sorting

Activeworkbook.SaveAs Filename:=Format(Range("B11").Value,"yyyymmdd")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"jatman" wrote in message
...
how do i save a file based on a predetermined value in a cell.

ex. the value in cell B11 contains a date. i want that date to be the
file
name that it gets saved as.

regards,

jat jaswal