How to maintain code?

[Sam Johnson]

I'm designing a Test-Case-Management VBA form for an excel spreadsheet.
Once it's completed, multiple copies will be made and distributed to
multiple users. My problem is how to maintain the code, once I release it.
i.e. if I want to change a form or a function, I don't want to edit the code
in every document. Ideally, I'd like to store all the VB code and Form
resources in a central place and have the Excel docs automatically load the
code\resources on startup.

Is there any way to do this? I'd appreciate any suggestions, I'm quite
stuck.

 

[Tushar Mehta]

You are asking the right questions. Too many people are simply so
thrilled at having developed a VBA solution that they first distribute
and then worry about maintenance. ;-)

I strongly recommend distributing the code in an add-in. Start with
http://www.mrexcel.com/board2/viewtopic.php?p=148963#148963

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

 

[Sam Johnson]

An add-in does seem like the way to go, but how to I go about updating an
Add-in once it's distributed?

Sam