you can import modules  in VBA under program control.
You have to use a set of objects in the VBA Extensibility Library. I
wrote an article about it in TechTrax:
pubs.logicalexpressions.com/.../LPMArticle.asp

See, in VBA, whether Word, Excel, Outlook, Access, etc. all the modules
are stored in the one document file (unlike VB6), such as a .doc, .xls,
.otm (Outlook), .mdb (Access). In VBA, if you see a .bas or .frm file on
your hard drive, it's because you exported it, or were about to import
it. But the system doesn't actually use these files -- you can use them
as backups of your modules or as a means of transferring them to other
documents, but VBA can't work with them directly -- it only works with
what's in the document file itself.