Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    printing VBA code (Windows nt/vba6)

    Hi

    I've tried to print out my VBA code for a source code review. However when i click on the print icon or use ctrl P, all i get is a blank page from the printer. I know there are downloads available such as printPrettyCode etc, but i;m not allowed downloads here. Is there any other way to just print off code, especially properly formatted (e.g. indenting etc)

    TIA
    Sheila

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: printing VBA code (Windows nt/vba6)

    Hi Sheila,

    You can export a module to a text file, then use Notepad or any text editor to print it. Or you can select all text in a module (Ctrl+A) and paste it into Word; you'll probably want to set the font to Arial 8 points or Courier New 8 points or something like that, then print from Word.

  4. #3
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing VBA code (Windows nt/vba6)

    Thanks again for the help Hans, though I should have thought of that myself......... There are just some days when my brain doesn't seem to work!!! <img src=/S/brickwall.gif border=0 alt=brickwall width=25 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
  •