Reply to thread

Message: [QUOTE="Jezebel, post: 5814036"] You can import modules (and forms) through VBA. Check help on the Import method: Application.VBE.ActiveVBProject.VBComponents.Import [FileName] But there's no way to deal with the password through VBA (not that I've ever found, anyway, and believe me, I've looked!). Nor through VB either, for that matter. Not even using SendKeys. For future reference, a better distribution strategy is to put the common code in an add-in. Then you have only one template to maintain, instead of 20. [/QUOTE]