I've just answered this question and your question here was referenced.
To also support your questions: -
Is Application.Filedialog(msoFileDialogSaveAs) support in Mac excel 2011 vba?
No it is not, however there is a built in function in Mac VBA called MacScript, which you pass applescript through to get a value back, see my previously linked thread for more detail on this.
Difference between Application.Filedialog(msoFileDialogSaveAs) and Application.Dialogs(xlDialogSaveAs)?
Open dialog box - lets users select one or more files that you can then open in the host application using the Execute method.
SaveAs dialog box - lets users select a single file that you can then save the current file as using the Execute method.
File Picker dialog box - lets users select one or more files. The file paths that the user selects are captured in the FileDialogSelectedItems collection.
Folder Picker dialog box - lets users select a path. The path that the user selects is captured in the FileDialogSelectedItems collection.
I've just answered this question and your question here was referenced.
To also support your questions: -
Is Application.Filedialog(msoFileDialogSaveAs) support in Mac excel 2011 vba?
No it is not, however there is a built in function in Mac VBA called
MacScript
, which you pass applescript through to get a value back, see my previously linked thread for more detail on this.Difference between Application.Filedialog(msoFileDialogSaveAs) and Application.Dialogs(xlDialogSaveAs)?
Application.Filedialog gives access to four file dialog style boxes: -
Application.Dialogs gives access to all built in dialogs available in Excel, one of which is the 'SaveAs' dialog.