Office365 Excel对工具的访问-> RegExp库的“引用"菜单 [英] Office365 Excel access to the Tools -> References menu for RegExp library

问题描述

这听起来像是一个简单的问题，但是我正在VBA中创建一个使用正则表达式的宏.事实证明，VBA本身并不支持正则表达式，因此我需要添加对"Microsoft VBScript正则表达式5.5"的引用，才能访问Excel中的正则表达式功能.

This might sound like a simple question but I'm creating a macro in VBA that uses regular expressions. It turns out VBA doesn't inherently support regex and I need to add a reference to 'Microsoft VBScript Regular Expressions 5.5' to gain access to regex functions in Excel.

我所有的在线搜索都告诉我，您需要转到工具->引用菜单来添加/删除可在VBA中使用的引用.

All my searching online tells me you need to go to Tools -> References menu to add/remove references that can be used in VBA.

从Google获得的Excel中的工具->引用"菜单

我一生都无法看到Excel中工具->引用"菜单的位置.我已启用开发人员"标签，但该标签不存在.

For the life of me I can't see where the Tools -> References menu is in my Excel. I've enabled the Developers tab and it's not there.

这就是我所看到的

如果有帮助，我在Mac上的Office 365(维基百科告诉我是Office 2016)上使用Excel.请帮助我找到如何在Excel中访问引用"菜单(无论是否可以通过工具"->菜单"或其他方式访问).谢谢.

If it helps, I'm using Excel on Office 365 (which Wikipedia tells me is Office 2016) on a Mac. Please help me find how I can access the References menu in Excel (whether or not it can be accessed via Tools -> Menu or some other way). Thanks.

推荐答案

您需要打开Visual Basic(对于应用程序)编辑器或VBE.在开发人员"选项卡上，查找"Visual Basic".它应该是最左边的项目.

You need to open the Visual Basic (for applications) Editor, or VBE. On the Developers tab, look for "Visual Basic". It should be the left-most item.

或者，您可以按Alt-F11.

Or, you can press Alt-F11.

您可以在VBE中找到工具"菜单和引用"子菜单.

The VBE is where you'll find the Tools menu, and the References submenu.

这篇关于Office365 Excel对工具的访问-> RegExp库的“引用"菜单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！