VBA - Back End Applications
When developing VBA applications for a considerable high amount of users, you should be able to control every user code from a centralized module. Think about a company with 500 users using an Excel application you built. The customers use Excel as a database to store monthly data. Every day they run an application that organizes new fields to the respective sheet. One day, you notice a bug that affects every user. Grabbing a fresh copy is not an option, every user will lose months of work. Your only option is to go computer by computer doing the manual update in their specific workbook or, creating an application that goes to everyone's computer, finds the workbook, open it, and modify the code. This last option is very, very risky and I would not recommend it at all. You could encounter a lot of problems while doing it. On the contrary, if everyone's Excel application could point to a centralized workbook where the code to run the procedures and functions is located, you w...