| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to change default file name in "save as" or "save"
Hello
could you tell me how to change the default file name in the dialog "save as" or "save" without opening the dialog or save the file tks in advance..... I am really stucked.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to change default file name in "save as" or "save"
I don't think you can do this
But you can use this FName = Application.GetSaveAsFilename("yourfilename", _ fileFilter:="Excel Files (*.xls), *.xls") See the VBA help for GetSaveAsFilename to get more information -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "gerard" wrote in message ... Hello could you tell me how to change the default file name in the dialog "save as" or "save" without opening the dialog or save the file tks in advance..... I am really stucked.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Change default settings of "Save external links values" | Excel Discussion (Misc queries) | |||
| Can I change Excel 2003 default "save to" folder? | Setting up and Configuration of Excel | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
| How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming | |||
Linear Mode
