Re: Is there any regexp and hashtable management in Excel VBA?
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Thu, 15 Feb 2007 14:13:02 -0500
On Thu, 15 Feb 2007 18:52:40 +0100, "Patrice" <patrice_nospam_.chevee@xxxxxxx>
wrote:
Tom Ogilvy wrote:
http://support.microsoft.com/default.aspx?scid=kb;en-us;818802&Product=vbbMmmm... I tried a lot of things, but it seems evident that even Excel for XP
HOW TO: Use Regular Expressions in Microsoft Visual Basic 6.0
Should work for VBA as well.
I can't say anything about hashtables except there is nothing built
in.
does not manage Regexps. I also tried to create a variable:
Dim X as Regexp
But the keyword "Regexp" is not available. That is too bad: I was forced to
use Perl in order to perform some lexical treatment (removing blang spaces,
formatting chains, and so on). THis was not convenient since I had to save
the text on the hard disk, perform the treatment with Perl, then import the
resulting text from the hard disk. Some things did not change since 1980...
You need to first set a reference:
One method -- on the VBA Top Menu Bar select Tools/References and select
Microsoft VBScript Regular Expressions 5.5
--ron
.
- Follow-Ups:
- References:
- Prev by Date: RE: Create List from Multiple Worksheets
- Next by Date: RE: Create List from Multiple Worksheets
- Previous by thread: Re: Is there any regexp and hashtable management in Excel VBA?
- Next by thread: Re: Is there any regexp and hashtable management in Excel VBA?
- Index(es):
Relevant Pages
|
