Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |