Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I'm trying to run a macro (created by Harlan Grove), using Excel 97 under Windows XP SP2, which requires "'Microsoft Scripting Runtime" and "Microsoft VBScript Regular Expressions 1.0". In the VBE under Tools, References, I can find the Scripting Runtime but not the VBScript Regular Expressions listed. As a result, the macro always stops when it gets to "Dim re As New RegExp". I've searched various web sites and it seems that if VBScript is installed (which it is, on my machine version 5.6) the reference should show up, but it doesn't. Could someone please tell me how to find the reference to Microsoft VBScript Regular Expressions 1.0? TIA Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Substring in excel? How about regular expressions? | Excel Discussion (Misc queries) | |||
Indicate missing number in a sequence (Part II) | Excel Discussion (Misc queries) | |||
need help righting script to sort rows alphabetically then seperate them to line up | Excel Worksheet Functions | |||
Regular expressions in Excel | Excel Discussion (Misc queries) | |||
Using a VB Script for barcodes - new to this | Excel Discussion (Misc queries) |