Cyberdude
03-22-2005, 11:09 AM
When I write a new macro, I have found it very useful (to me) to do two thiings:
1. Add a comment to the "Sub" line that shows the last date modified, and a list of macros that call this macro.
2. On the "End Sub" line to add a comment that contains the name of the macro. Example:
Sub ClearOldData() '3/22/05 [Called by "Cre8Entry"]
...
End Sub 'ClearOldData'
I'd like to automate this procedure. When I enter the name of a new macro (Sub ClearOldData()), then the editor automatically adds the "End Sub" line. I'd like to take this a step farther, and perform the tasks I mentioned above. I would probably have to write another macro and invoke it, but I have no idea how to write a macro that modifies an existing macro. Am I asking for too much??
1. Add a comment to the "Sub" line that shows the last date modified, and a list of macros that call this macro.
2. On the "End Sub" line to add a comment that contains the name of the macro. Example:
Sub ClearOldData() '3/22/05 [Called by "Cre8Entry"]
...
End Sub 'ClearOldData'
I'd like to automate this procedure. When I enter the name of a new macro (Sub ClearOldData()), then the editor automatically adds the "End Sub" line. I'd like to take this a step farther, and perform the tasks I mentioned above. I would probably have to write another macro and invoke it, but I have no idea how to write a macro that modifies an existing macro. Am I asking for too much??