From many years I have been working on VBA based automation projects using Excel, Outlook, Word, Access and other technologies. As a professional developer it was my responsibility to test the tools with all possible scenarios and data. Proper testing of the tools helps to deliver bug free and quality tools to clients.
If you are also a programmer and developing a tool or application. You should always test your tool with all possible scenarios that may come in production environment.