Set a reference to Microsoft VBScript Regular Expressions(vbscript.dll)

[cate]

In vba, how do you do that?
Thank you.

 

[cate]

In vba, how do you do that?
Thank you.

Sorry, I had no idea how simple it was. Tools->References->[x]
Microsoft VBScript Regular Expression 5.5

 

[John Bundy]

Its about halfway down
Microsoft VBScript Regular Expressions 5.5

 

[Rick Rothstein]

That's one way to do it... you can also do it through code.

Dim RegExp As Object
.......
.......
Set RegExp = CreateObject("vbscript.regexp")

--
Rick (MVP - Excel)

In vba, how do you do that?
Thank you.

Sorry, I had no idea how simple it was. Tools->References->[x]
Microsoft VBScript Regular Expression 5.5