Thread
:
Regexp needed in Excel 2000
View Single Post
#
10
Mr. Me
Posts: n/a
On Mon, 1 Aug 2005 21:26:26 -0400 in article <OJ$9vEwlFHA.708
@TK2MSFTNGP09.phx.gbl,
spoke thusly...
I get a compile error:
User-defined type not defined
Hi Biff.
In the vba editor, go to Tools | References.. |
and look for something similar to:
"Microsoft VBScript Regular Expressions 5.5"
Check this to add it to vba.
If VBScript Regex is not in the list of references already, add the dll c:
\winnt\system32\vbscript.dll. That's what I had to do.
--
Sig: Say no to fixed width HTML tables. They look terrible in most browsers.
Reply With Quote