04 RegexMode - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

RegexMode compile constant

Indicates which algorithm to use for regular expression calculation.

Applies to

TableData ArrData RsetData Xdata XShared

When evaluating regular expressions with the RegExpr function in ArrData, the normal method is to use Microsoft VBScript regular Expressions 5.5. This will happen when the RegexMode compile constant is True. However Microsoft have suggested that VBScript will be withdrawn at some point. So an alternative calculation method using Jscript has been included. This is selected by setting RegexMode to False.