Can't set correct filter for SaveAs dialog

[Yobanlong]

Hi

I am using Excel as a GUI to produce a text file that will be read by another program. Basically, the user will put in data in a spreadsheet, and save these data as a text file (I want to use file ending *.wan). I need to have a SaveAs dialog so that the user can select a folder and a filename for the file.

I have tried to use Application.FileDialog(msoFileDialogSaveAs) but I am not able to set the correct filters, I only get the standard Excel fily types.

Does anybody know how I can set the correct filters, or another method I can use to get a SaveAs dialog with a ".wan" filter?

 

[Yobanlong]

Sorry folks! I figured it out! This one works fine, I post it in case anybody else needs it.

FileSavename = Application.GetSaveAsFilename( _
                      InitialFileName:="", _
                      FileFilter:="Water analysis (*.wan),*.wan")