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