Programming The VBA Editor describes methods for programmatically interacting with the VBE editor. Quote:"You can use these features to write custom procedures that create, change, or delete VBA modules and code procedures." The article is written for Excel but I think it should be adaptable to Access. (I haven't tried it yet- if you try it let me know how it works!)
Thanks for posting this! The guidance is close, but still needs tweaking for Access. For example, they have a few variants that they say will work, such as:
ReplyDeleteSet VBAEditor = Application.VBE
But for Access, you need to use:
Set VBProj = Application.VBE.ActiveVBProject
But once you adjust to the slight differences between the Excel and Access models, it's a good place to start.
Take a look at this job posting -
ReplyDeletehttps://jobs-hersheys.icims.com/jobs/4833/job