Application GetSaveAsFilename Method Method

Purpose

Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.

Syntax

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

Optional Parameters

InitialFilename

Specifies the suggested file name. If this argument is omitted, Microsoft Excel uses the active workbook's name.

FileFilter

A string specifying file filtering criteria.

FilterIndex

Specifies the index number of the default file filtering criteria, from 1 to the number of filters specified in FileFilter. If this argument is omitted or greater than the number of filters present, the first file filter is used.

Title

Specifies the title of the dialog box. If this argument is omitted, the default title is used.

ButtonText

Macintosh only.