regex string matching

Jamie Martin · Sep 25, 2003

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 · Sep 25, 2003

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 · Sep 25, 2003

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 · Sep 26, 2003

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

regex string matching

Jamie Martin

Dana DeLouis

Tom Ogilvy

Tushar Mehta