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.
Anyone have other tips?
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