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.