Mac Excel 2011中的Application.Filedialog支持 [英] Application.Filedialog support in Mac excel 2011

问题描述

问题对

• Mac excel 2011 vba中是否支持Application.Filedialog(msoFileDialogSaveAs)?
• Application.Filedialog(msoFileDialogSaveAs)和Application.Dialogs(xlDialogSaveAs)之间的区别?

推荐答案

我刚刚回答了

I've just answered this question and your question here was referenced.

也要支持您的问题:-

Mac excel 2011 vba中是否支持Application.Filedialog(msoFileDialogSaveAs)?

不是，但是在Mac VBA中有一个内置函数，称为MacScript，您可以通过它传递applescript以获取值，有关此的更多详细信息，请参阅我以前链接的线程.

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.

Application.Filedialog(msoFileDialogSaveAs)和Application.Dialogs(xlDialogSaveAs)之间的区别?

Application.Filedialog 允许访问四个文件对话框样式框:-

Application.Filedialog gives access to four file dialog style boxes: -

• 打开对话框-用户可以选择一个或多个文件，然后使用Execute方法在主机应用程序中打开它们.
• 另存为"对话框-允许用户选择一个文件，然后您可以使用Execute方法保存当前文件.
• 文件选择器"对话框-允许用户选择一个或多个文件.用户选择的文件路径将在FileDialogSelectedItems集合中捕获.
• 文件夹选择器对话框-允许用户选择路径.用户选择的路径将在FileDialogSelectedItems集合中捕获.

• 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 允许访问所有内置于对话框中的对话框(在Excel中可用)，其中之一是另存为" '对话框.

Application.Dialogs gives access to all built in dialogs available in Excel, one of which is the 'SaveAs' dialog.

这篇关于Mac Excel 2011中的Application.Filedialog支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！