Results 1 to 4 of 4

Thread: Sharing tips on Macros - Documentation for the boss
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2006
    Posts
    257
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sharing tips on Macros - Documentation for the boss

    I now have a number of Macros and need to show them to my bosses. As you know presentation is everything. I would rather not have to cut and paste the macros into word to clean them up and print them out. My documentation is OK - what I am looking for is tips - printing a new macro starting on a new page, making the code more readable etc.
    For example this is what I put at the beginning of each macro that uses more than 5 variables or calls more than 3 other macros - no reason for the 5 or 3 rule but is where I have started.
    Code:
    Sub CreateUploadCSV()
    ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    'Name: CreateUploadCSV - Create todays UpLoad.CSV
    'Disc: Using todays Master.xls file create todays UpLoad.CSV file
    'Rev#  Author   Comment
    '  0     DVC      Origin
    'In:   Todays Master.xls
    'Out:  Upload.csv in same directory as Master.xls
    'Call:
    'Misc:
    ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    'Declare:
    'Initialize:
    'Start of Routine
    End Sub
    Anyone have other tips?
    Darrell

  2. #2
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,390
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you are prepared tp pay for it, have a look at VBA CodePrint (www.ozgrid.com/Services/print-vba-code.htm). There are also Contents and Index pages produced.
    I have used it for several years and wouldn't be without it.
    If you have software to print to a PDF file, even better - I use JAWS PDF (www.jawspdf.com)
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  3. #3
    Board Regular
    Join Date
    May 2006
    Posts
    257
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    d3p2j5b
    thanks for the info on Codeprint will look into it.
    Darrell

  4. #4
    New Member
    Join Date
    Jun 2009
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: Sharing tips on Macros - Documentation for the boss

    Not bad. Recently I have found this PDF Creator in the net. It supports Windows Vista.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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