It would help to show the lines(s) which are causing the error.

Tim

--
Tim Williams
Palo Alto, CA


"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!!!