regex string matching

[Jamie Martin]

Can VBA do regex string matching? Can it do a conditional replace based on
what was found?

If not and I wanted to spend a million hours working on it, is it
theoretically possible for a VBA procedure to pass a string to Perl?

Thanks for your help,

Jamie

 

[Dana DeLouis]

On my system, it is found by going to the VBA editor, <Tools> <Reference>
and selecting:

'// Microsoft VBScript Regular Expressions 5.5

HTH.

 

[Tom Ogilvy]

this article talks about VB6, but it would be the same in VBA (create a
reference to the specified object model).

http://support.microsoft.com/default.aspx?scid=kb;en-us;818802&Product=vbb
HOW TO: Use Regular Expressions in Microsoft Visual Basic 6.0

 

[Tushar Mehta]

One more reference to what you've already got:

Regular Expression Object Properties and Methods
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/script56/html/vtoriregularexpressionsobjectpropmeth.asp

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions