Common Code in Access - Excel - Power Point Programs

  • Thread starter Thread starter CLarkou
  • Start date Start date
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 ?
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ViewSonic VX2758A-2K-PRO-3 Gaming Monitor with 2K and 240Hz Unboxing 2
Secure code in Excel & Power Point ADD-INS 8
Load xlam everytime open excel 6
Import data from Access to Excel containing VB code 3
Alt codes 4
Book Recommendation? 2
Open Another Database in Read Only Mode 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Back
Top