vba utilities

[Anonymous]

Are there any utilities available to list user variables and whether they are actually ref'd in a project? Any other kind of analyzer/checkers?

[Anonymous]

If you turn on the Option "Require Variable Declaration" it will add "Option Explicit" to any new modules. For existing modules, manually add it. Then when you compile it will automatically id any variables not declared. -- ---- Ed ---- "Ryan" wrote in message news:415473df$1_1@newsprd01... > Are there any utilities available to list user variables and whether they > are actually ref'd in a project? Any other kind of analyzer/checkers? > >

[Anonymous]

Ed, I believe he's actually looking for a utility to identify dead variables. I don't know of any such utility. "Ed Jobe" wrote in message news:4154762d$1_3@newsprd01... > If you turn on the Option "Require Variable Declaration" it will add "Option > Explicit" to any new modules. For existing modules, manually add it. Then > when you compile it will automatically id any variables not declared. > > -- > ---- > Ed > ---- > "Ryan" wrote in message > news:415473df$1_1@newsprd01... > > Are there any utilities available to list user variables and whether they > > are actually ref'd in a project? Any other kind of analyzer/checkers? > > > > > >

[Anonymous]

Ok, I get it now. It seems like I saw something like that once. I'll have to try and remember where. -- ---- Ed ---- "VBA" wrote in message news:415477fb$1_3@newsprd01... > Ed, > > I believe he's actually looking for a utility to identify dead variables. I > don't know of any such utility. > > > "Ed Jobe" wrote in message > news:4154762d$1_3@newsprd01... > > If you turn on the Option "Require Variable Declaration" it will add > "Option > > Explicit" to any new modules. For existing modules, manually add it. Then > > when you compile it will automatically id any variables not declared. > > > > -- > > ---- > > Ed > > ---- > > "Ryan" wrote in message > > news:415473df$1_1@newsprd01... > > > Are there any utilities available to list user variables and whether > they > > > are actually ref'd in a project? Any other kind of analyzer/checkers? > > > > > > > > > > > >

[Anonymous]

Ryan: This company have a very interesting products: http://www.aivosto.com/products.html -gnb "Ryan" wrote in message news:415473df$1_1@newsprd01... > Are there any utilities available to list user variables and whether they > are actually ref'd in a project? Any other kind of analyzer/checkers? > >

[Anonymous]

MZ Tools ---> www.mztools.com Best part is they are FREE! Be sure to download the right one as there is one specific to VBA and one for VB. You need both if you have both. -- Mike ___________________________ Mike Tuersley CADalyst's CAD Clinic Rand IMAGINiT Technologies ___________________________ the trick is to realize that there is no spoon...

[Anonymous]

I second that. These tools make life in the IDE easier !! -- Saludos, Ing. Jorge Jimenez, SICAD S.A., Costa Rica "Mike Tuersley" wrote in message news:l55xuz9v5rnu$.vcbs0bo4518y.dlg@40tude.net... > MZ Tools ---> www.mztools.com > > Best part is they are FREE! Be sure to download the right one as there is > one specific to VBA and one for VB. You need both if you have both. > > -- Mike > ___________________________ > Mike Tuersley > CADalyst's CAD Clinic > Rand IMAGINiT Technologies > ___________________________ > the trick is to realize that there is no spoon...