| Microsoft Office 2000 Developer | |
The VBA Error Handler add-in inserts pre-formatted error handler blocks into one or more procedures in a project. The error handler format is based on formatting instructions stored in a template file (.eht).
For More Information For more information about using the VBA Error Handler, see Automating Error Handling.
Add Error Handlers To
Determines whether error handlers will be added to the current procedure, all procedures in the current module, or all procedures in the current project.
Error Handling Template
Contains the path to the template file (.eht) that contains formatting instructions for the error handler. Enter the path and file name, or use the Browse button to search for a template file.
Update Existing Error Handlers
When selected, updates all existing error handlers within the scope selected in the Add Error Handlers To group so they match the currently selected template.
Note If the Error Handler finds "On Error Goto <label>" within a procedure in existing code, no modifications are made to that code. If the Error Handler finds "On Error Goto <0>" or "On Error Resume Next" within a procedure, the code is modified to match the information specified in the template. The following comment is placed directly before the exiting On Error code:
' TODO: Turn normal error handler on when this condition is finished
Author
Contains the name and initials of the person adding the error handler. With the default template, this information appears as part of the error handler. This information is stored in the registry for future use. If you do not enter information, the name and initials default to the registered user of the product.
Show Template
Displays the Show Template dialog box, allowing you to view the contents of the currently selected template.
Note The Show Template dialog box doesn't allow editing. To edit the template file, open it in Notepad or another text editor. For more information about the templates, see Code Commenter and Error Handler Template Formats.