Configuration Management in VBA

[BruceB]

I am wondering how VBA programmers manage the code that they write, say in an
MS Project environment. How do I, for example, add a version number to a
class module that I have written so that I can see it without having to open
the module in an editor to read the change log in the module itself? I can't
just add a version number or date to the module name without then having to
change all references to that module in other forms and code modules. Is
there third-party software that helps with this sort of thing?

Also, is there a streamlined way of importing forms and code modules into a
new Project application (i.e., create a new VBA project) that brings them in
all at once, rather than having to invoke the VB editor and laboriously
import them one at a time?

 

[Jack Dahlgren]

You can use the organizer to move modules back and forth. I typically store
the code in a blank project file if I need to keep a copy. Then move it into
the global.mpt file if needed.

I also use comments for version control. If you want more a more
sophisticated development environment you probably want to use something
like visual studio and write add-ins. VBA is designed to be quick and
simple. It does not have all the bells and whistles.

-Jack Dahlgren

 

[BruceB]

Jack- Thanks for the helpful comments. I hadn't considered using the
Organizer, which seems to make the process a bit easier. However, it doesn't
seem to allow me to copy the "ThisProject" module (MS Project object), where
I put code to effect new command buttons, etc. Any suggestions about that?

 

[Rod Gill]

For security reasons Microsoft has disabled this in all Office programs. The
only way to install is manually.

Another way is to share the same Global.Mpt file from the Network so you
only have to setup macros in one Global.mpt or have your IS team push out a
fresh Global file to everyone.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx