View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Revolvr[_2_] Revolvr[_2_] is offline
external usenet poster
 
Posts: 9
Default Improved printing of VBA code?

I found software called PrettyCode.Print that works well, at:

http://www.prettycode.com/?nav=products.pcp

It is a bit overkill for what I need, and expensive, but generates very nice
output.

Cheers,

-- Rev

"Revolvr" wrote in message
news:YXK3b.9443$QT5.1344@fed1read02...
Printed VBA code is harder to read than on-screen. I would like to copy

and
paste the code into Word then format it to be more readable, including for
example:
* Changing font to Courier
* Change color of comments
* Bold Subroutine/Function and end Sub/Function lines
* Other?

Has anyone created Word macros to improve the formatting/readability of
printed VBA code?

TIA

-- Rev