View Single Post
  #10   Report Post  
Mr. Me
 
Posts: n/a
Default

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.