How do I set up a cell which should be suggested as file name to s
 

How do I set up a cell whitch should be suggested as the file name to save
when "SAVE AS" is clicked?
For example on a worksheet
B2 is a date,(AUG-1-05)
A1="SCHEDULE FOR "&YEAR(B2)&MONTH(B2)&DAY(B2)
A1 will be "SCHEDULE FOR 200581"
On the window that opens after clicking on "SAVE AS", how I can do, to bring
"SCHEDULE FOR 200581" to the box of the suggested file name to save.
Thanks.

You need code

Activeworkbook.SaveAs FileName = Range("A1").Value

--

HTH

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


"Rick1950" wrote in message
...
How do I set up a cell whitch should be suggested as the file name to save
when "SAVE AS" is clicked?
For example on a worksheet
B2 is a date,(AUG-1-05)
A1="SCHEDULE FOR "&YEAR(B2)&MONTH(B2)&DAY(B2)
A1 will be "SCHEDULE FOR 200581"
On the window that opens after clicking on "SAVE AS", how I can do, to
bring
"SCHEDULE FOR 200581" to the box of the suggested file name to save.
Thanks.