ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting the default filename in xlDialogSaveAs (https://www.excelbanter.com/excel-programming/298897-setting-default-filename-xldialogsaveas.html)

John Wirt[_6_]

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




All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com