I am currently developing and/or supporting about 6 different app's, and going crazy with slightly different versions of VBA routines. Can you pull the VBA out of an mdb (2003) and put it in another ?container?, and link to it with a Reference?
If so, any pitfalls? Other than having to completely re-test EVERYTHING to find & fix all the spots that will be broken, due to the coding differences?
I seem to remember seeing an article about this in the past, but can't find it now.