Common Code in Access - Excel - Power Point Programs

C

CLarkou

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 ?
 
B

Bill Foley

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