Use the programmer’s text editor (I use UltraEdit) and do a bulk search of your project source directories.
Start by looking for Variant
(obviously), although you probably already did.
Next, use a regular expression type search for something line by line:
*Dim [a-zA-Z][a-zA-Z0-9_]*\p
This should get a Dim x
script without an end As DataType
.
Use *Dim [a-zA-Z][a-zA-Z0-9_]*,.*
To search for script types Dim a, b, c As Integer
.
Use *Dim .*, [a-zA-Z][a-zA-Z0-9_]*,.*
For scenarios with an odd ball, for example Dim a As Integer, b, c As Long
Repeat the above bindings with Private
and Global
instead of Dim
, and this should get almost everything.
tcarvin
source share