VBA and Regular expressions

[pfsardella]

Here are some MicroSoft articles on Regular Expressions.

http://msdn.microsoft.com/workshop/languages/clinic/scripting051099.asp
http://msdn.microsoft.com/library/d...tml/reconIntroductionToRegularExpressions.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsobjRegExp.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;818802&Product=vbb

HTH
Paul

 

[Chip Pearson]

Fritz,

In VBA, go to the Tools menu, choose References, and set a
reference to the "Microsoft VBScript Regular Expressions 5.5"
object library. This will allow you to use regular expressions via
the RegExp object.

 

[Friedrich Muecke]

Hi,

how to use Regular expressions with VBA without buying an additional tool or
using Perl.
Any possibility to do some vbs and to use the output of an
regexp.vbs-Function out of vba?

thanks for your time + effort in advance.

fritz

 

[Friedrich Muecke]

that's cool and not that far away. Should have thought of this.
Thanks a lot !!!
)

fritz