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

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

On Feb 18, 10:52 am, "greg" <iu...@ghfhg.com> wrote:
> 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.

thanks, i will take a look.


"greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>