Common Code in Access - Excel - Power Point Programs

I developed a program in Access. Then I developed add-ins in Excel &
Power Point with common modules from Access database.

What is the solution for not having to copy+paste code from Access to
Excel & Power Point ? Can I have my code in a common file and call it
from all 3 programs ?

I'm sort of confused as to what you want to do. VBA within each of the
Office products is different because of the different objects that you can
do things on ( or to). For example, you manipulate data in "fields" in
Access, "cells" in Excel", "text boxes" in PowerPoint, etc. You are working
on these objects on different platforms as well (forms - Access, workbooks -
Excel, slides - PowerPoint). Therefore the object modeling is different
between programs.

What exactly is this "program" you created in Access and how/why are you
trying to incorporate the code into Excel and/or PowerPoint?

--
Bill Foley
www.pttinc.com
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
<[email protected]> wrote in message
news:[email protected]...
> I developed a program in Access. Then I developed add-ins in Excel &
> Power Point with common modules from Access database.
>
> What is the solution for not having to copy+paste code from Access to
> Excel & Power Point ? Can I have my code in a common file and call it
> from all 3 programs ?
>