View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bhupinder Rayat
 
Posts: n/a
Default Searching for codes in text strings

Thanks Ron,

but now it doesnt like Set mc = re.Execute(rSearch.Text), error message says
"Object variable or With block variable not set".

Any ideas?

Thanks again,

Bhupinder

"Ron Rosenfeld" wrote:

On Wed, 26 Apr 2006 04:24:01 -0700, Bhupinder Rayat
wrote:

Hi Ron,

wow thats impressive!

Thank you for opening up the world of RegEx to me, I can certainly utilise
it and create little programs that will help my team greatly!

Still couldn't get Ardus's code to compile though. I even used createObject
and linked to vbscript, and it then recognised the RegExp command, but it
still didn't like the MatchCollection command. Any Ideas?

Thank you for your help.

Bhupinder


For Ardus's version, you need to set a reference (Tools/References) to
"Microsoft VBScript Regular Expressions 5.5" which should be in the dropdown
list.


--ron