Sharing VBA code among several databases

Sharing VBA code among several databases

Post by QnJpYW » Thu, 22 Feb 2007 00:43:32


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
 
 
 

Sharing VBA code among several databases

Post by Marshall B » Thu, 22 Feb 2007 03:22:03


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/

--
Marsh
MVP [MS Access]