From: Ron Rosenfeld on 15 Apr 2010 21:36
On Thu, 15 Apr 2010 11:34:54 -0700, "Joe User" <joeu2004> wrote:
>Dim v As Object
>v = CreateObject("vbscript.regexp")
>I have select Microsoft VBScript Regular Expressions 5.5 (also tried 1.0)
>under Tools > References.
>But nothing is added under VBAProject \ References in the Project pane, as
>there is when I select atpvbaen.xls for example.
>Is that indicative of the root cause of the problem, perhaps a missing file?
>What is the name of the file that contains the Microsoft VBScript Regular
>Expressions 5.5 library?
You must SET an object.
Dim v as Object
set v = createobject("vbscript.regexp").
If you select Tools/References VBScript Regular Expressions 5.5, then one
syntax would be:
Dim v as RegExp
Set v = New Regexp
Set v = Nothing