Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Printing code (O2K sr1)

    Is there any way that I can print out my code on a colour printer and have all of VBA's colouring included? The colour definitely helps on-screen, and I would really like to have it in my printed archives as well.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    PrettyCode.Print v2.0 is a utility ($89), which can do what you want.

    You can download an evaluation copy.

    Andrew C

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Printing code (O2K sr1)

    Another option, which I prefer, is VBACodePrint. You can download an evaluation, but it will only print up to 3 pages of code and it puts a notice across the pages. This is also an inexpensive product but very useful. The 97 version has problems but the VBACodePrint version, which is for 2000 and 2002, works quite well.
    Charlotte

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    Check out this page too. You can try the software for 45 days.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    Thanks all. So it appears that I have not missed some cryptic colour-print option setting in VBA after all. <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15> For what I work with though, I think I'll stick to the low-tech option and use a highlighter instead. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    PrettyCode.Print 1.50 appears to be freeware. I don't know if it supports the required features though. 3.04MB

    or here
    <img src=/w3timages/blackline.gif width=33% height=2>
    Ultimate Visual Basic/VBA source code printing and documenting solution which prints Visual Basic source code with preview, auto indentation, fonts/colors selection, line bracket connections and many other features. This version adds a line numbering feature, predefined B&W and color schemes, line wrap marks and
    <img src=/w3timages/blackline.gif width=33% height=2>

    Publisher : Serge Baranovsky
    Date added : 2002-11-10
    Rating : No Rating
    File size : 2.64 MB
    Language : English
    License : Freeware
    Price : $0
    Limitations : No Limitations
    OS : Win95 98 ME NT 3.x NT 4.x 2000
    Requirements : No special requirements


    Alan

  7. #7
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    Yes PCP V1.x does print in colour.

    I have been using 1.x for a few years now and it's great.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    Funny. If you check out the website, version 1.x is not mentioned. All it has in there is version 2.0, which isn't freeware anymore.

    Luckily, the 1.5 download link still works <g>.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    <P ID="edit" class=small>(Edited by d_rasley on 09-Jul-03 08:17. Follow-up on download links provided -- the free version does not seem to be available anymore.)</P>Also interesting about the link... The 'screenshot' link on the v1.5 page goes to the v2.0 page, making it sooo much easier to see & buy the newer version. An excellent marketing tactic! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    The <img src=/S/free.gif border=0 alt=free width=30 height=15> version looks like it will do what I was hoping to do. I think the largest project I've worked on was about 10 pages long, not really enough to justify a paid-for solution, but I could definitely see paying <img src=/S/money.gif border=0 alt=money width=17 height=15> for the programs if I were more heavily into coding.
    <img src=/w3timages/redline.gif width=33% height=2> <img src=/w3timages/redline.gif width=33% height=2>

    I followed both links and the zip files that were available contained the new 2.0 version, not the older 1.5. A little Googling turned up a lot of other links to v1.5 but they all went to the author's site and linked to the newest, non-free version. <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>

  10. #10
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    Sorry about the bum steer. I was "caught" too with the old descriptions, but the new links. I had a bit of a scrounge, but my guess is that all the old freeware versions have been pulled from the web. Pity... still, you can't blame a guy for wanting to make some money on his investment. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Alan

  11. #11
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing code (O2K sr1)

    That'll happen from time to time, but the one thing that struck me as odd was that looking through Google's archived links showed the program was listed on a number of sites but all their links pointed back home - no mirrors at all. It also didn't show up on any 'personal' software archive lists, such as Mercury Freeware.

    Did the v1.5 EULA contain the fairly-standardized Freeware licensing language regarding sharing & redistribution? (Share the program as much as you like, but the entire file and at no cost?) If so, perhaps someone with an old intallation file could keep the free version alive. <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23> <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •