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?
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?