Distributing Updates to VB/Excel Programs
Posted on 2002-05-13
I've written 2 Excel spreadsheets with VB code that have been distributed to other users. Each user uses multiple copies of these spreadsheets. When I develop updates to the programs, there are dozens of copies of the spreadsheets that require updated code. Most users are not familiar with VB, so manually copying code from one file to the other is not an option.
I'm looking for a solution where all the user has to do is click another button and the code is copied from one file to another. Because the worksheets are typically copied from one file to another, my code is stored within the worksheet rather than modules. Also, I'm using command buttons and their Click events to trigger the macro.