In large and complex VBA projects I use my own centralized error handling system. Error Handling procedure sends all error descriptions to the web service which save them into the database, so me and other developers can support VBA code easy even if a lot of users work with it in different locations. Users don't need to spend their time to send me any log files, I always have the most resent log from each user. It's possible to see all error messages as well as pivot reports (on the image sample you can see pivot report with unique errors only).
I'm experienced VBA developer focused on creating of advanced business tools for Microsoft Excel. Also I work with other Microsoft Office applications such as Word, Outlook, PowerPoint, Access, Visio. And I'm not just a developer, I'm experienced business consultant with a Master's degree in project management and a Bachelor's degree in finance. Worked as IT project manager and CIO in manufacturing, retail, real estate development and marketing companies with from 15 to 20000 employees.