Prev: Automated Copy Paste
Next: Active sheet problem / macro button
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
....
....
....
'and maybe
Set v = Nothing
--ron
First  |  Prev  | 
Pages: 1 2
Prev: Automated Copy Paste
Next: Active sheet problem / macro button