Hi,

Early of late binding.

If early, try late
==> in place of Set RE = New Regexp
use Set RE = CreateObject("vbscript.regexp")

And define (Dim) your RE as OBJECT s.

Regards,

Daniel M.

"Chris W." <anonymous@discussions.microsoft.com> wrote in message
news:4f2101c5230f$ee968290$a601280a@phx.gbl...
> Hi, Someone had given me a routine to test for invalid
> emails using The VBscript RegExp Object. It works great,
> but when I try to migrate it to my enduser they get a
> Compile error. when I comment out the reference to the
> Vbscript object, No compile error. Can anyone tell me if
> there is a compatible functionality available for pattern
> matching in VBA, or does anyone have a routine in VBA that
> filters out invalid emails. Thank you!!!