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: -
- 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.
Application.Dialogs gives access to all built in dialogs available in Excel, one of which is the 'SaveAs' dialog.
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
