Application.GetSaveAsFileName

This method can be used to display a saveas dialog box.
This should not be used but is still available for backwards compatibility.
To save a file you should use the Application.FileDialog - SaveAs method.

Excel

SS

sFullPath = Application.GetSaveAsFileName(InitialFilename, FileFilter, FilterIndex, Title, ButtonText) 

All the arguments are optional.

sFullPath = Application.GetSaveAsFileName 

If the user cancels, this method returns False
If multiselect is False, this method returns a String
If multiselect is True, this method returns a String Array

Word

Does not exist

PowerPoint

Does not exist