Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Declare RegExp from Vbscript.dll | Excel Programming | |||
RegExp to Parase File paths | Excel Programming | |||
How do you look for two distinct patterns (RegExp) | Excel Programming | |||
Regexp needed in Excel 2000 | Excel Discussion (Misc queries) | |||
putting data from hashtable into Excel Validation list | Excel Programming |