View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 108
Default 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