Using Regular Expressions in Excel VBA
The RegExp Object is accessed in Excel (all versions) via either Early or Late
Binding. Early Binding requires that a VBA reference is set from the Visual Basic
Editor via Tools References Microsoft VBScript Regular Expression 5.5. The
reference can be set programmatically. Sub Make_VBS_Ref(). On Error Resume
Next.