simpler to use Format for date, no international issues then, and better to
format as yyyymmdd for sorting purposes

Format(Date, "yyyymmdd")

--
HTH

Bob Phillips

"Stefi" wrote in message
...
Put

"C:\REPORTS\" & Range("A1").Value & Replace(Date, ".", "") & ".xls"

in place of the filename! Substitute "A1" with the cell reference you want
to get the name from!

Regards,
Stefi



"Jonathan" ezt írta:

I have set my Excel file to save to a aprticular location, however I
want to
be able to have the filename made up from the value in a worksheet cell
i.e.

Currently I have

ChDir "C:\REPORTS"
ActiveWorkbook.SaveAs Filename:="C:\REPORTS\mailinglist.xls",
FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False

I want where the file name is mailinglist.xsl to be populated by a value
from a cell i.e. colleges21092005.xls (cellvalue+currentdate+filetype)

Any pointers would be greatly appreciated!


Tia