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

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

'// Microsoft VBScript Regular Expressions 5.5

HTH.
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Jamie Martin" wrote in message
...
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

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...02&Product=vbb
HOW TO: Use Regular Expressions in Microsoft Visual Basic 6.0

--
Regards,
Tom Ogilvy


"Jamie Martin" wrote in message
...
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

One more reference to what you've already got:

Regular Expression Object Properties and Methods
http://msdn.microsoft.com/library/de...l=/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

In article , lionsmouth2002
@yahoo.com says...
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