Use VBA Code to Save class modules imported into Access
Posted on 2012-04-05
I have a vba routine that successfully imports modules (from .cls and .bas files) into my Access 2010 project (.accdb). I am now trying to save those modules using vba.
I have tried this command---Call SysCmd(504, 16483). Although no error occurs, none of the modules is saved.
I have an active "reference" to Microsoft Visual Basic for Applications Extensibility, and I imported the modules using the VBIDE.VBComponents object. Can anyone tell me how to use code to save modules successfully imported?