Sharing VBA code among several databases

[Guest]

I have written several VBA modules that I would like to share among several
Access databases. Is there any way to do this without the obvious Copy &
Paste from one db to another? I am hoping to store them all in a single
place so that when they get changed, I don't have to remember to Copy & Paste
into x number of db's.

Thanks in advance to anyone who replies.

Brian

 

[Marshall Barton]

I have written several VBA modules that I would like to share among several
Access databases. Is there any way to do this without the obvious Copy &
Paste from one db to another? I am hoping to store them all in a single
place so that when they get changed, I don't have to remember to Copy & Paste
into x number of db's.

You can put all those general procedures in modules in their
own mdb file. Then the other database files can use that as
a library by setting a reference to it.

You set a reference from the VBA window using the Tools -
References menu item/