Unexpected error message when trying to define VBA regex REPLACE method

Solution 1:

Remove the parenthesis from this part of your code:

regExObject.Replace (parmInvocationParm, Replacement)

It should be:

regExObject.Replace parmInvocationParm, Replacement

If you keep the parenthesis, then you must use Call statement:

Call regExObject.Replace (parmInvocationParm, Replacement)