MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Printing VBA Code

  Asked By: Demyan    Date: Sep 02    Category: MS Office    Views: 2435

I was just asked by a fellow developer if I knew of a way to print out
all my VBA code in one fell swoop rather than going into each object and
printing that section and continuing on through all the user forms and
other places that code hides, and it occurred to me that you all might
want to know about the tool that I use to do that. It is called
VBACodePrint and can be purchased for $59.00 from
www.starprint2000.com/vbaprint_features.html. Once installed it
shows up as a menu item in the VBE and it allows you to print the
Declarations, the Selection, the Current Procedure, the Current
Component, the Current Project or All Projects.

I have found it pretty invaluable for documenting my code. In fact I
run the Current Project Print before I release my project from the
development stage and move it into production.

When I print to PDF, it helps me create a code library of all the
procedures I use - because as we all know, there is no sense in
reinventing the code if it is already done for you. <grin>



4 Answers Found

Answer #1    Answered By: Adalia Fischer     Answered On: Sep 02

For the non-professional on a limited budget ... Are there any freeware
tools that do a similar function? I've been looking thru various web
sites with no success yet. Sourceforge and UniversalIndentGui came
close but did not have a syntax for vba  code.

Answer #2    Answered By: Tracy Myers     Answered On: Sep 02

IMHO the best one you'll get is PrettyCodePrint at

There is a nag and a title in the footer unless you pay for it. If you can
live with that then it's er... Free.

BTW.. What message is this a reply to please? What date and so on?... Or is
the title just wrong?

Answer #3    Answered By: Vonda Ramirez     Answered On: Sep 02

it seems that 'PrettyCode.Print for .NET' is not free for us. ;(

Answer #4    Answered By: Bach-yen Nguyen     Answered On: Sep 02

I didn't quote the entire base note in my reply, But Dawn Crosier
back in '04 had mentioned VBACodePrint so I just used that note as
the starting point to keep the VBA code printing  tool discussion in
one thread. Entire base note below. I'm not a big fan of using
shareware without paying, feels like a violation of the honor system.
If the other product is just nagware that is trying to nag you into
buying the full-featured product then I have no issue.

Thanks for the pointer on PrettyCode.Print.

Didn't find what you were looking for? Find more on Printing VBA Code Or get search suggestion and latest updates.