Sunday, April 12, 2009

Programming The VBA Editor

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!)


Brandon said...

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:
Set 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.

Access said...

Take a look at this job posting -