Analyzing and reviewing VBA Code

[Cosmos75]

(Not sure where I should have asked this questions. Moderators, please feel free to move this thread if I asked this in the wrong place)

How do you go about reviewing and writing code?

I have a project to automate a tedious process at work that involves controlling another program from Excel. This other programs has it’s own programming language that is very similar to VBA.

I am close to finishing this project but am having a major headache trying to review my code for lines that are redundant, not used, where I performing the same or similiar procedures repeatedly and so on.

I am certain that part of the problem is that I just jumped into writing the code with not much of a plan of attack other than trying to break the code into chucks that perform a particular task and then one “all-in-one” that calls the separate functions.

My question is what tools do you use to review your code (VBA in general)?

Here are some tools that I have found

Printing VBA Code
http://www.starprint2000.com/
http://www.prettycode.com/

Code Flowcharting (Big differences in prices but I haven’t looked into all the features!)
http://www.kunzlertech.com/ ($17.95)
http://www.fatesoft.com/s2f/ ($99.95)
http://www.aivosto.com/visustin.html ($249)

Code Analyzer?
http://www.aivosto.com/project/project.html

Do any of you use tools or does it just boil down to programming practices?

 

[Mile-O]

Do any of you use tools or does it just boil down to programming practices?

For me it is just practice.

Sometimes I can code something and then, on looking back, I can see how to simplify it.

 

[bjackson]

check out this
http://www.mztools.com/
Its an amazing add in for free
Regards
Bjackson

 

[Cosmos75]

check out this
http://www.mztools.com/
Its an amazing add in for free

I am actually using that! The "Procedure Caller" feature is WONDERFULL! Helped me get rid of procedures that wasn't being used! But I was only able to do that because I had broken my code into chucks by what they did!