RegEx-implemation not working on Mac/Office11 (RegexExample.xlsm)? [Solved]

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 4.83 out of 5)
Go back to All Questions Login or Register
Solved705 views

Excel Regex Tutorial (Regular Expressions)

Hey Scripters,
i dont have any expirience in Excel, but I do script InDesign. And I need a RegEx in Excel, and found your brilliant guide. Im fiddeling around with another code snippet and yet I dont get any of these to work.
I guess it can have something to do with my crappy MacOS (10.12.6) Office 2011 (v14.7.7 b170905), because I assume your “RegexExample.xlsm” is flawless.

My Excel keeps showing: #VALUE! …where the Output is.

Strange thing is: The Quicklook-Feature from MacOS does show this:

which should be the real thing.
So, which kind of noobish (Excel-)mistake am I making here?


Hi Fritz sorry for late reply but indeed almost all examples that use system objects or Excel libraries only supported on Windows – will not work on Mac.

In general I do not recommend creating advanced VBA scripts on a Mac.

Simply the best place to learn VBA!