Here are some MicroSoft articles on Regular Expressions.

http://msdn.microsoft.com/workshop/l...ting051099.asp
http://msdn.microsoft.com/library/de...xpressions.asp
http://msdn.microsoft.com/library/de...sobjRegExp.asp
http://support.microsoft.com/default...02&Product=vbb

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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

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.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Friedrich Muecke" wrote in message
...
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

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

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

fritz

"Chip Pearson" wrote in message
...
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.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Friedrich Muecke" wrote in message
...
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