VBA RegExp causes Compile error while vbscript.regexp works
I know this question was already successfully answered, I just wanted to add a solution that worked for me.
Tools -> References - > "Microsoft VBScript Regular Expressions 5.5"
was already activated.
Set regex = New RegExp
caused a compile error.
Set regex = New VBScript_RegExp_55.RegExp
works.