PDA

View Full Version : Solved: VBA indenter



BrianMH
01-30-2013, 03:56 AM
Hi all,

Does anyone know of a standalone or web based vba indenter/beautfier? I know I can post code with vba tags on the test forums but I was curious if there was anything else. I'm aware of smart indenter but that needs admin access so I can't use it at work.

Thanks

Aussiebear
01-30-2013, 04:17 AM
Do a quick Google search and you'll find quite a number

xld
01-30-2013, 04:22 AM
This generally seems to be the best received http://www.oaltd.co.uk/indenter/default.htm

BrianMH
01-30-2013, 05:46 AM
Thanks guys. I've spent quite a bit of time googling this, I'm never one to ask a question with out trying to find the answer myself. I found smart indenter which I mentioned in my post. It says "detected corrupt install" when I try to install it. I believe this is due to not having admin access to the machine. I can't really find anything standalone that I don't have to install. Oh well I'll just continue doing preview mode in the test forum.

JKwan
01-30-2013, 07:56 AM
Try this out:
http://andrewexcel.blogspot.ca/search?updated-min=2012-04-01T00:00:00%2B09:00&updated-max=2012-05-01T00:00:00%2B09:00&max-results=2

xld
01-30-2013, 09:47 AM
If you don't have admin rights, it is unlikely you have trusted access to VBA which you will need to run an auto-indenter.

BrianMH
01-31-2013, 02:19 AM
Try this out:
http://andrewexcel.blogspot.ca/search?updated-min=2012-04-01T00:00:00%2B09:00&updated-max=2012-05-01T00:00:00%2B09:00&max-results=2

Thanks JKwan that works great. It is a normal addin instead of an installer so I was able to use it. I think I saw his blogs in the google search yesterday but couldn't get to them due to the silly filtering here at work. For those with the same issue the direct link to the website (not the blog) is http://www.andrewsexceltips.net/downloads.htm

Thanks again.