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

1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 4.88 out of 5)
Loading...
Go back to All Questions Login or Register
Solved1088 views
0

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:
RegEx
Hello
456
5

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

0

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.