PDA

View Full Version : Modules and forms autoupdate



PaulColbert
08-22-2023, 08:07 PM
Hello everyone.

I have a form called Customer List that 50 people in our company use (individually) to basically to a CRM type thing. They each maintain their own list. Sometimes I find bugs in the code (vba modules and/or userforms) and want to update them, but I have to manually update everyone's forms (because they all have data in them that needs to be retained, rather than them starting over with the "new" fixed form).

Is there a way to auto update all the modules and forms (kind of like auto importing them in replacing the old ones?) automatically with a macro or something?
Thanks in advance for any leads, ideas, pointers, etc!

Aflatoon
08-23-2023, 07:43 AM
I would suggest that you separate code from data, perhaps by putting the code into a separate add-in. That way you can simply distribute new versions of the add-in without having to worry about losing existing data. You can also store the add-in centrally so that you only need to update the central copy.