Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to use a VBScript regular expression to parse a string in VBA.
Can some kind soul get this to work? Thanks. Sub x() Dim s As String s = "First Name: Joe" Set regEx = CreateObject("VBScript.RegExp") regEx.Pattern = "First Name: (\w+)" Set Matches = regEx.Execute(s) ' This statement fails - no such property Set oMatch = Matches.subMatches(0) ' I can enumerate through Matches but the enumeration doesn't include "Joe" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can someone help me with this regular expression? | Excel Discussion (Misc queries) | |||
Help with regular expression | Excel Programming | |||
Regular Expression | Excel Discussion (Misc queries) | |||
Declare RegExp from Vbscript.dll | Excel Programming | |||
Regular Expression for cell address | Excel Programming |