Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Code Documentor (XL2000)

    In the past I have printed out my source code for various projects and have been less than thrilled with the resultant hard copy. I searched on this forum first and didn't find anything that would be of assistance ... is there a add-in to facilitate the printing out of source code? I could always copy and paste into Word and then clean up after, but surely someone has come up with a solution to the vanilla printout from Excel.

    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  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: Code Documentor (XL2000)

    You can get a utility at .<A target="_blank" HREF=http://www.jn-software.com/>StartPrint</A> which will help with printing source code. However the software is commercial but you can download a trial version

    Andrew C

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    The attached workbook should do what you want. It will create either a RTF or plain text file that can be printed from Word or Wordpad. It does not currently work for Class modules though. Open the workbook, click on the print button and follow the instructions.
    Attached Files Attached Files
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    Thank you very much...this is just what the doctor ordered.

    Brent

  5. #5
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    ...and thanks to you for your assistance. I will try out the print code.

    It would be nice if one day I can help someone out as the both of you do daily. This forum is always full of great information. I thank you once again.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  6. #6
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    Did you have a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=vb&Number=66280&page=&view= &sb=&o=&vc=1>this thread</A>?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  7. #7
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

    Sir,

    I searched on print code, code print, vba code, document vba, document vba code, print source code ..... I didn't search on print code in color. *hangs head in shame*

    But once again this forum comes through in an exemplary fashion. I am not worthy! But am appreciative of all the assistance. Thanks.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    It's much easier to do the search when you remember that there's actually something else out there <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    And a hint for the next time you search. The default search option is to search on a phrase. If you don't find a search on the exact phrase, also try using the "and" option, which finds any post with all the the search words in the whole post, not just as an exact phrase.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  9. #9
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    and as for the search hint ... <img src=/S/blush.gif border=0 alt=blush width=15 height=15> ... i should know better. Thanks Geoff.

  10. #10
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Code Documentor (XL2000)

    Legare

    Is the workbook only working on XL 2000? I tried to work with it with XL 97 and it gave me a "Can't find project or library" on the line that looks like:

    strCurProc = obCode.ProcOfLine(lDLines + 1, vbext_pk_Proc) possibly the vbext_pk_Proc is doing it.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: Code Documentor (XL2000)

    Wassim,

    The project or library you are having difficulties with is most likely the Microsoft Visual Basic for Applications Extensibility Library x.x, wher x.x is the version number.

    In the VB editor, go to Tools, References, and make sure you select whatever version of the above library you have.

    Andrew C

  12. #12
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code Documentor (XL2000)

    I wrote this a couple of years ago, and I think I was running 97 at the time on the computer I wrote it on. I don't have 97 available at the moment, so I can't try it there. I hope Andrew's suggestion will work for you.
    Legare Coleman

Posting Permissions

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