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.