I would like to create a script (preferrably in access (2007)) that would ("The Builder")
a) open access file with my code in it "The Master".
b) copy that access file (to "The Production File")
c) apply vbe code (from "The Builder") to code in the second ("Production") file.
In fact I have the code to insert errorhandling code via VBE. I would like to code without any handling code in my master access file. Then I would like to copy the master file to a "production file" and apply the vbe code to the production file.
I'm looking for ways to access the "activeproject" or the "codeproject" of a non currnet database. Should I be looking into addins or are there simpler ways to realise this.