The Excel GetSaveAsFilename Method

The GetSaveAsFilename method is very similar to the GetOpenFilename method. It displays a Save As dialog box and lets the user select (or specify) a file. It returns a filename and path but doesn't take any action. Like the GetOpenFilename method, all of the GetSaveAsFilename method's arguments are optional.

The syntax for this method is:

 Application.GetSaveAsFilename(InitialFilename, FileFilter, FilterIndex, Title, ButtonText) 

The arguments are:

• InitialFilename : Optional. Specifies the suggested filename.

• FileFilter : Optional. A string specifying file-filtering criteria.

• FilterIndex : Optional. The index number of the default file-filtering criteria.

• Title : Optional. The title of the dialog box.

• ButtonText : For Macintosh only.