Save a File with a cell value

[Guest]

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

 

[Guest]

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:

 

[Bob Phillips]

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

Format(Date, "yyyymmdd")

 

[Guest]

Yeees, I forgot that I have a specific default date format with "."s!
Stefi


„Bob Phillips†ezt írta: