Regular Expressions in VBA

[Spencer Torene]

Hi,

I'm trying to put together a form in Outlook, and I want to use a regular
expression to find a section of a file so I can modify only that part. I've
tried looking for regular expressions in VBA on the internet, but I can't
find any good sources. Does anyone have a good place to look or have a
quick primer?

Thanks!

 

[Sue Mosher [MVP-Outlook]]

Try:

http://msdn.microsoft.com/library/en-us/dnclinic/html/scripting051099.asp
http://authors.aspalliance.com/brettb/VBScriptRegularExpressions.asp

 

[Spencer Torene]

Thanks, Sue.

I had already read about RegExps in VBScript, but then I guess I don't
understand the relationship between VBA and VBScript. You can use these
objects/methods in VBA as well? How does VBScript relate to VBA?


Try:

http://msdn.microsoft.com/library/en-us/dnclinic/html/scripting051099.asp
http://authors.aspalliance.com/brettb/VBScriptRegularExpressions.asp

 

[Sue Mosher [MVP-Outlook]]

VBA has no RegEx object of its own. Use CreateObject to instantiate one from the VBS library, as the samples show.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Spencer Torene]

Ah, thank you.

I feel that these are the types of things that are really lacking
explanation from Microsoft. There are many things that I learn from other
people's code, and can't find any CLEAR reference to in their language
reference library.


VBA has no RegEx object of its own. Use CreateObject to instantiate one from
the VBS library, as the samples show.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Wolfram Jahn]

I feel that these are the types of things that are really lacking
explanation from Microsoft. There are many things that I learn from other
people's code, and can't find any CLEAR reference to in their language
reference library.

Be thankful.
This makes our job so challenging.

Wolfram

 

[Spencer Torene]

Oh how true

You've just given me a new outlook on my budding career.