Microsoft Visual Basic For Applications In Excel Mac
- Microsoft Visual Basic For Applications In Excel Mac 2016
- Windows Visual Basic
- Microsoft Visual Basic For Applications In Excel Mac 2017
- Microsoft Visual Basic For Applications In Excel Mac 2017
Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac. Office for Mac for Visual Basic for Applications (VBA) Microsoft Docs Skip to main content. IdMso compatible avec Office 2016 pour Mac idMSOs compatible with Office 2016 for Mac. Pour plus d'informations sur les idMso compatibles avec Office 2016 pour Mac, consultez les rubriques suivantes: For information about the idMSOs that are compatible with Office 2016 for Mac, see the following: idMSO pris en charge dans Excel pour Mac idMSOs supported in Excel for Mac. Fully illustrated and easy-to-follow tutorial about the Excel Visual Basic (VBA) Editor. Learn how to use Microsoft Excel and Visual Basic for Applications now. Excel Visual Basic (VBA) Editor: The Complete And Easy Guide To The VBE. What is the aspect about learning macros and Visual Basic for Applications that you find more. Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was declared legacy in 2008, and its associated integrated development environment (IDE). Although pre.NET Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010.
使用您为 office for Mac 中的 office for Windows 开发的 VBA 外接程序和宏。Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac.
适用于: Excel for Mac PowerPoint for Mac Word for Mac 适用于 Mac 的 Office 2016Applies to: Excel for Mac PowerPoint for Mac Word for Mac Office 2016 for Mac
2017-2-24 Microsoft Excel 打开现有的工作簿时，您会收到以下错误 ︰ 'Visual Basic for Applications （VBA） 此工作簿中的宏已损坏，并且已被删除。' 打开现有的工作簿 在开发人员和查看功能区下， Visual Basic、宏和录制宏选项被禁用。Microsoft PowerPoint 和宏已被. Microsoft Visual C Redistributable for Visual Studio 2019 This package installs run-time components of Visual C libraries and can be used to run such applications on a computer even if it does not have Visual Studio 2019 installed. An identified security issue in Microsoft® Visual Basic® for Applications could allow an attacker to compromise a Microsoft Windows®-based system and then take a variety of actions. By installing this update, you can help protect your computer.
如果要为 office for Mac 创作宏, 则可以使用 VBA for office 中提供的大部分相同的对象。If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office.有关 Excel、PowerPoint 和 Word 的 VBA 的信息, 请参阅以下内容:For information about VBA for Excel, PowerPoint, and Word, see the following: Excel 2019 for mac issues.
备注
Outlook for mac 和 OneNote for mac 不支持 VBA。Outlook for Mac and OneNote for Mac do not support VBA.
Office 2016 for Mac 已沙盒化Office 2016 for Mac is sandboxed
与支持 VBA 的 office 应用程序的其他版本不同, office 2016 for Mac 应用程序是沙盒中的。Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
沙盒将限制应用程序访问应用容器外部的资源。Sandboxing restricts the apps from accessing resources outside the app container.这会影响涉及跨进程的文件访问或通信的任何加载项或宏。This affects any add-ins or macros that involve file access or communication across processes.您可以通过使用下一节中介绍的新命令来最大限度地减少沙盒的影响。You can minimize the effects of sandboxing by using the new commands described in the following section.
创建安装程序或放置用户内容Creating an installer or putting user content
有关为你的外接程序创建安装程序的说明, 请参阅以下文章:在 Office 2016 for Mac 中安装用户内容For instructions on creating an installer for your add-in, please refer to the article here: Installing User Content in Office 2016 for Mac
适用于 Office 2016 for Mac 的新 VBA 命令New VBA commands for Office 2016 for Mac
以下 VBA 命令是 Office 2016 for Mac 的新的和唯一的。The following VBA commands are new and unique to Office 2016 for Mac.
| CommandCommand | 用于Use to |
|---|---|
| GrantAccessToMultipleFilesGrantAccessToMultipleFiles | 请求用户一次访问多个文件的权限。Request a user's permission to access multiple files at once. |
| AppleScriptTaskAppleScriptTask | 从 VB 调用外部 AppleScript 脚本。Call external AppleScript scripts from VB. |
| MAC_OFFICE_VERSIONMAC_OFFICE_VERSION | 在编译时, 在不同 Mac Office 版本之间的 IFDEF。IFDEF between different Mac Office versions at compile time. |
Office for Mac 中的功能区自定义Ribbon customization in Office for Mac
适用于 Mac 的 Office 2016 支持使用功能区 XML 进行功能区自定义。Office 2016 for Mac supports ribbon customization using Ribbon XML.请注意, office 2016 for Mac 和 office for Windows 中的功能区支持存在一些差异。Note that there are some differences in ribbon support in Office 2016 for Mac and Office for Windows.
| 功能区自定义功能Ribbon customization feature | Office for WindowsOffice for Windows | Office for MacOffice for Mac |
|---|---|---|
| 能够使用功能区 XML 自定义功能区Ability to customize the ribbon using Ribbon XML | 可用Available | 可用Available |
| 支持基于文档的外接程序Support for document based add-ins | 可用Available | 可用Available |
| 使用自定义功能区控件调用宏的能力Ability to invoke Macros using custom ribbon controls | 可用Available | 可用Available |
| 自定义菜单的自定义Customization of custom menus | 可用Available | 可用Available |
| 能够在自定义功能区选项卡中加入和调用 Office 熟知控件Ability to include and invoke Office Fluent Controls within a custom ribbon tab | 可用Available | 最熟悉的 office 熟知控制标识符与 office for Mac 兼容。Most familiar Office Fluent Control Identifiers are compatible with Office for Mac.有些可能不可用。Some might not be available.对于与适用于 mac 的 office 2016 兼容的命令, 请参阅与 office 2016 for mac兼容的 idmso。For commands that are compatible with Office 2016 for Mac, see idMSOs compatible with Office 2016 for Mac. |
| 支持使用自定义功能区控件的 COM 加载项Support for COM add-ins that use custom ribbon controls | 可用Available | 适用于 Mac 的 Office 2016 不支持第三方 COM 加载项。Office 2016 for Mac doesn't support third-party COM add-ins. |
与 Office 2016 for Mac 兼容的 idmsoidMSOs compatible with Office 2016 for Mac
Microsoft Visual Basic For Applications In Excel Mac 2016
有关与适用于 Mac 的 Office 2016 兼容的 idmso 的信息, 请参阅以下内容:For information about the idMSOs that are compatible with Office 2016 for Mac, see the following:
Windows Visual Basic
另请参阅See also
Microsoft Visual Basic For Applications In Excel Mac 2017
支持和反馈Support and feedback
Microsoft Visual Basic For Applications In Excel Mac 2017
有关于 Office VBA 或本文档的疑问或反馈？Have questions or feedback about Office VBA or this documentation?请参阅 Office VBA 支持和反馈，获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.