Use VBA to Save a Class Module or Standard Module?

[Pelegrinus]

Using VBA code, I successfully add or import a standard module or class module into my current accdb Access database (2010). The newly added module shows accurately in the VB Editor window, its name is the correct name for the module, and it executes properly. BUT, it is not saved yet in the CurrentProject object. How can I use VBA code to save the module without having to take any manual steps (e.g., when I manually save the module, I am asked to confirm the module name; when I have to do this with multiple modules that I import, the process is tedious). I've looked in Application.VBE.ActiveVBProject.VBComponents and in Application.CurrentProject but have not seen anything that solves my question. (CurrentProject.UpdateDependencyInfo will save the module put requires that I confirm the module name.) I REALLY would appreciate any specific suggestions.

 

[vbajock]

This might help:

http://msdn.microsoft.com/en-us/library/bb214062(v=office.12).aspx