| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify a default file name in VB when the Save / Save As command.
Hello,
I would like to specify a default file name when a user selects either the Save or Save As commands from the Menu bar in excel. I have thought about inserting a button on the excel spreadsheet and using VB to load the Save / SaveAs dialog box, but this would mean disabling the normal Save / Save As menu command buttons. The default File name would include a static name XXX followed by todays date. Any advise would be greatly apprieciated. Many Thanks SM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I disable the Save command for an Excel file? | Excel Discussion (Misc queries) | |||
| Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
| How do I set the save default not to include .xls in name of file | Excel Discussion (Misc queries) | |||
| "Save As" default is a .txt file | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
Threaded Mode
