Pelegrinus
New member
- Local time
- Today, 04:30
- Joined
- Dec 29, 2011
- Messages
- 1
I use vba code to successfully import a module from an Explorer directory (typically a .cls or .bas file in that directory) into my current accdb database. The module (either a class module or a standard module) shows accurately in the VB Editor window. BUT, the module is not saved in the database, and it does not show up in currentdb.Containers("Modules").Documents.Count.
Because I can import dozens of standard and class modules using VBA code, I have the problem of saving these modules in the database. If I manually click the save button in the VB Editor, I have to individually name and save each module (even though I'm content to use the default name, I have to click OK for each file). I want to write code to add the modules to the Modules container of the CurrentDB. I can't figure out how to do that. Does anyone have any suggestions?
Because I can import dozens of standard and class modules using VBA code, I have the problem of saving these modules in the database. If I manually click the save button in the VB Editor, I have to individually name and save each module (even though I'm content to use the default name, I have to click OK for each file). I want to write code to add the modules to the Modules container of the CurrentDB. I can't figure out how to do that. Does anyone have any suggestions?
