Upgrade scenario of VBA program: suggestions welcome

[webster188]

Hi,

I have written a VBA application which basically is using Excel as a database where data can be retrieved from another application, users can view the data and add comments, or additional data via a UseForm.
The data is stored over multiple worksheets.

Sometimes, users will ask for new features or report bugs. So now and then, I update my code and release a new version of the application.
What is not yet intelligent organised is the way I deal with these upgrades.

At present, I convert the file of each user manually to upgrade them to the new version, basically, I am just copy/pasting the existing data from the old to the new version.

What would be a better way to approach this? Any suggestions are welcome.

Thanks in advance for your input

 

[Ardus Petus]

Put all your code in one xlsm with no data.
So you can sent a new xlsm to your end users whenever you have an upgrade

HTH
--
LR