| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a default nam e in a SAVE AS dialog box
In a cell I have a date, such as 9/1/08. Lets call this cell A5.
What I want to do is come up with the code to open a SAVE AS box and prepare to save the worksheet with the default name of the previous month and year, in this case it would be "Aug 08". The user could accept this or change it if he needed to. Another example would be the date in A5 would be 10/5/08 would open the SAVE AS box and have "Sep 08" as the suggested or default name... ready to save. Thanks for any help you can give. Jonco |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting a default path name under Save As Dialog Box | Excel Programming | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| Default Cell Values & Save Changes Dialog Box | Excel Discussion (Misc queries) | |||
| change default file path in Save As dialog box | Excel Programming | |||
Threaded Mode
