asked on

Distributing Updates to VB/Excel Programs

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.

Any suggestions??

Thanks,
Brian

Richie_Simonetti

It is not a simple task!
First, you need to save current "version" of worksheet in somewhere (maybe an ini file)
Second, it is better to store the code in modules, you can "easily" access it.
To me, the best you can do is using templates to do the work and with vb/vba replacing existing sheets using new templates.
As i said, not an easy task, you need to open every old sheet, update to new ones and save them.

bv31723

ASKER

Please allow me about one week to think about how to implement your suggestion. In the meantime, I'm still open to other suggestions.

Thanks,
Brian

ASKER CERTIFIED SOLUTION

Richie_Simonetti

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Richie_Simonetti

Why did you punish me with "B" grade?
If you need more help, ask for further details would be enought.
Don't you know how to create an add-in? I have example of how to do it.

bv31723

ASKER

Sorry Richie, I clicked the wrong grade. Should have been an A. How do I change the grade?