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