ExcelBanter - Application.FileDialog(msoFileDialogSaveAs)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Application.FileDialog(msoFileDialogSaveAs) (https://www.excelbanter.com/excel-programming/406457-re-application-filedialog-msofiledialogsaveas.html)

greg

Application.FileDialog(msoFileDialogSaveAs)

thanks, i will take a look.

"greg" wrote in message
...
Hello,
If I want to create my own save as dialog. Using the
Application.FileDialog.
But I want to have my own file extension. Can that be done?
This does not seem to work?

thanks

With Application.FileDialog(msoFileDialogSaveAs)

.Filters.Clear
.Filters.Add "Run Data File", "*.csv"
.AllowMultiSelect = False
.Show
.Execute

End With

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