Tool to clean up VBA code

[anthony20069]

Hi guys,

firstly, not sure if this is in the right place, so apologies if it is not.

Can anyone recommend a tool or something to tidy up VBA code?

Cheers

Ant

[Paul_Hossler]

http://www.appspro.com/Utilities/CodeCleaner.htm


This will clean the code, and I think will do a little reformatting

Are you looking for a 'pretty print' tool?

Paul

[Bob Phillips]

Depends upon what you men by clean-up.

If you want it to remove code bloat, Code Cleaner is the tool. If you want it to indent your code, Smart Indenter will do it. If you want it to take your rubbish code (No criticism, my code is rubbish too), and turn it into some readable and maintainable code, dream on :).

[anthony20069]

By 'pretty print' tool - do you refer to something that will format the code correctly? if so, yes :)

by Clean-up - i mean merely to format i.e. indenting etc - Do you ahve a link for Smart Indenter?

[Bob Phillips]

http://www.oaltd.co.uk/indenter/indentfrm.htm

[GTO]

... If you want it to take your rubbish code (No criticism, my code is rubbish too), and turn it into some readable and maintainable code, dream on :).

:funnyashe Too funny Bob :clap: