How to do regular expression pattern matching from a VBA macro?

[Dave Jenkins]

I have a macro in which I'd like to take advantage of regex processing.

1) I don't see any built-in support in VBA - am I missing it somewhere?
2) Is it possible to utilize Java classes from within VBA? How?

 

[Bob Buckland ?:-\)]

Hi Dave,

You may want to post this in the MS Office developer newsgroup
(link below).

=======
I have a macro in which I'd like to take advantage of regex processing.

1) I don't see any built-in support in VBA - am I missing it somewhere?
2) Is it possible to utilize Java classes from within VBA? How?
--
Dave Jenkins<<
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.officedev
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.officedev

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Dave Jenkins]

Thanks, Bob.

I discovered last night that I could use vbscript classes to do the regex
searching, and I'm off and running.