Would be nice to have an add-in that updated a procedure comment when you changed the source code for that procedure. For example, here is a simplified view of my procedure comments that contains a tested date field:
'----------------------------------------------------------
' optRotate_Validate
' TESTED: 2004-02-03 Grok
'----------------------------------------------------------
Private Sub optRotate_Validate(Index As Integer, Cancel As Boolean)
If mProfile Is Nothing Then Exit Sub 'no profile selected
mProfile.RotatePage1 = Index
End Sub
Now if I were to edit the code in that procedure, other than the comments, the Add-In could invalidate the tested date and write "NOT TESTED" in its place.
Has anyone written Add-Ins?
It would seem that this could be adapted to produce error handling code, potentially to dump error information on a by-subroutine basis to a textfile of some sort as well as maintain comments as you said. Either way, it's an interesting idea that would prove greatly useful -- what kind of power are we given through Add-Ins?