Application.FileDialog(msoFileDialogSaveAs)

[greg]

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

 

[ward376]

Try putting quotes around your file name - "MyCustomFile.mcf". You'll
still have to specify the file type and watch that your extension
isn't a duplicate of an extension already associated with an
application.

Cliff Edwards

 

[cliu23]

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

http://msdn2.microsoft.com/en-us/library/aa219834(office.11).aspx

I am not sure if it's the problem.

 

[greg]

thanks, i will take a look.