I have an access database on one of our network drives that has some visual basic programming in it. In this programming is a function that looks at data and manipulates it a certain way and I would like to be able to call into my excel files.

The creator of this program constantly uses it in access and is always updating the program. If I were to just simply copy and paste every once in a while I would miss any edits that he makes to the program. Another reason that I want to link to it is because many of us use this program and it would be great if we can just draw from one source. Any ideas? Is this possible?