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

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

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

On Dec 1, 7:28*am, cate wrote:
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

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

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)


"cate" wrote in message
...
On Dec 1, 7:28 am, cate wrote:
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