|
|
ABC ~ All
'Bout Computers
The Online Web-azine for Computer
Enthusiasts
-- brought to you by
contents page for this issue
How many of you have tried to print out your
VBA code in the hopes of sitting down and going over it to try to
troubleshoot a problem? Maybe tried to print it for posterity sake? Maybe
even print out someone else's code to try to learn from it and follow the
logic? If you have tried to print your VBA code you have probably learned
one very disappointing fact, the nice color-coded code does not remain when
printed. That makes it rather hard to read.
I don't normally endorse products here. However, there is a free application
available on the web that takes care of this annoyance. It is called
PrettyCode.Print from
http://www.VBCity.com. This is a simple file that allows you to import
your VBA code and print it out to a color printer and retain the nice
formatting. As an added bonus it also groups your logic. This can prove to
be an invaluable troubleshooting tool if you have faulty logic or a
mismatched loop. It groups the following logic for you:
With… End With
Do… Loop
If…Then… Else
The nice thing about it is that it shows each component of your statement
linked by a single line. Each level is included so if you embed an If… then…
Else within a Do…Loop, it still shows up as a unique grouping. Your code is
unchanged other than the lines to help in your grouping.
VBCity does require that you register the product online but that is a free
process and this is definitely a valuable tool for such a minor hassle. If
you would like to check it out for yourself, visit:
http://www.vbcity.com/page.asp?p=pcp_index
<<<back to contents
James La Borde works
in the computer department at a Credit Union,
where he uses Access, SQL Server, VBA, and ODBC daily. He also
teaches online Access classes at
Eclectic
Academy.
|
|
,
