23Handling Errors

IN THIS CHAPTER

What Happens When an Error Occurs

Basic Error Handling with the On Error GoTo Syntax

Generic Error Handlers

Train Your Clients

Errors While Developing Versus Errors Months Later

The Ills of Protecting Code

Case Study: Password Cracking

More Problems with Passwords

Errors Caused by Different Versions

Next Steps

Errors are bound to happen. You can test and test your code, but after a report is put into daily production and used for hundreds of days, something unexpected will eventually happen. Your goal should be to try to head off obscure errors as you code. Always be thinking of what unexpected things could someday happen that would make your code not work.

What Happens When an Error Occurs

Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial