Sharing VBA code among several databases

B

Brian

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
 
M

Marshall Barton

Brian said:
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.
Click to expand...


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/
 
Top