How to assign the value returned by the regex execute function to a variable?

AJBoy

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
I have a regex for pattern matching and once the match has been found the matched value has to be assigned to a variable

I used this snippet and it has been returning an error stating invalid procedure call or argument

Set M = regexpLocation.Execute(subjct)
Location = M(0).Value

How can i assign the matched value to Location, so that i can move the Location value to an excel cell?
 
Top