Mac上具有Excel VBA的RegEx [英] RegEx with Excel VBA on Mac

问题描述

我需要将regEx与Excel VBA一起使用.我正在使用Mac OS 10.10和Office2011.因此没有可以使用的DLL文件.

I need to use regEx with Excel VBA. I'm using Mac OS 10.10 and Office 2011. So there is no DLL file I can use.

在这里做什么?

我读到我必须绑定一个Apple脚本.如何完成以及该脚本需要什么内容?

I read I've to bind an apple script. How is this done and what content does this script need?

推荐答案

从本质上讲，您不能真正做到-AppleScript对于这种事情(与VBA有关)实际上并不那么好

Natively, you can't really - AppleScript isn't actually that good for this kind of thing (where VBA is concerned)

您还可以安装和使用其他库来支持Mac OS上的正则表达式之类的东西-我见过最多的库是Satimage，尽管我个人还没有使用过(所以)我自己不能担保:

There are other libraries that you can install and use to allow support for things like regular expressions on Mac OS - the one I've seen used the most is Satimage although I've not personally had to use it (yet) so can't vouch for it myself:

http://www.satimage.fr/software/zh/downloads/downloads_companion_osaxen.html

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