| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the default filename in xlDialogSaveAs
I would like to set the default filename in the filename window when the
SaveAs Dialog box opens. Is this possible? bnSave = Application.Dialogs(xlDialogSaveAs).Show I would like the xlDialogSaveAs window to open with the filename of, say, "ts051604.xls." How can I do this? The file from which the xlDialogSaveAs is run is not ts051604.xls. John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting the default filename in xlDialogSaveAs
Hi,
you are on the right track... just do this bnSave = Application.Dialogs(xlDialogSaveAs).Show("ts051604 .xls") hope this helps........... John Wirt wrote: I would like to set the default filename in the filename window when the SaveAs Dialog box opens. Is this possible? bnSave = Application.Dialogs(xlDialogSaveAs).Show I would like the xlDialogSaveAs window to open with the filename of, say, "ts051604.xls." How can I do this? The file from which the xlDialogSaveAs is run is not ts051604.xls. John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Global Setting For All Workbooks - Filename In Footer | Excel Worksheet Functions | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
| Trouble setting variable as filename with date | Excel Programming | |||
| Setting the default file name in the XLDialogSaveAs dialog box | Excel Programming | |||
| Problem setting directory in xlDialogSaveAs | Excel Programming | |||
![John Wirt[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
