Upgrade scenario of VBA program: suggestions welcome

webster188

New Member
Joined
Oct 20, 2010
Messages
31
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Ardus Petus

New Member
Joined
Feb 24, 2020
Messages
13
Office Version
2019
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,000
Messages
5,465,937
Members
406,453
Latest member
MarkB5432

This Week's Hot Topics

Top