LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Is there any regexp and hashtable management in Excel VBA?

Patrice,

REGEX
======
The Regexp is very limited. If you want to use real regular
expressions, you're better off buying a 3rd party library. I thought I
was going to need one at one point, and the only one I found is this
one for $99 from Aivosto: http://www.aivosto.com/regexpr.html

HASH TABLES
============
The best way to create hash tables in Excel VBA is to set a reference
to the Microsoft Scripting Runtime library. It contains a Dictionary
object that works like a Perl hash structure. The help samples all use
strings, but you can also store objects in them.

Quick Tip 1: Word's object model also includes a Dictionary object, so
if you're doing any automation of Word from Excel make sure to fully
declare your variables like "Dim d As Scripting.Dictionary" instead of
just "Dim d As Dictionary".

Quick Tip 2: After installing and setting references to the libraries,
hit F2 to open the Object Browser. Select the regex or scripting
library from the drop down to see the available properties and
methods. Excel's VBA usually won't launch the Help file for a
referenced library when you hit F1, so this is often the fastest,
easiest way to find out what you want to know.

HTH,

Nicholas Hebb
BreezeTree Software
http://www.breezetree.com


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Declare RegExp from Vbscript.dll Bob Phillips Excel Programming 0 January 16th 07 07:45 PM
RegExp to Parase File paths bv003 Excel Programming 5 November 1st 06 05:37 PM
How do you look for two distinct patterns (RegExp) ExcelMonkey Excel Programming 1 August 7th 05 11:29 PM
Regexp needed in Excel 2000 Mr. Me Excel Discussion (Misc queries) 14 August 2nd 05 08:01 PM
putting data from hashtable into Excel Validation list Arsi Excel Programming 0 October 26th 04 06:07 PM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"