PDA

View Full Version : Tool to clean up VBA code



anthony20069
02-01-2013, 05:00 AM
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
02-01-2013, 06:57 AM
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
02-01-2013, 09:10 AM
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
02-01-2013, 09:16 AM
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
02-01-2013, 09:20 AM
http://www.oaltd.co.uk/indenter/indentfrm.htm

GTO
02-01-2013, 05:37 PM
... 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: