By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,965 Members | 1,170 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,965 IT Pros & Developers. It's quick & easy.

Common Code in Access - Excel - Power Point Programs

P: n/a
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 ?

Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 17 Nov 2005 22:49:47 -0800, CL*****@gmail.com wrote:
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 ?


Create a COM add-in project in Visual Basic 6. The code you wrote should be
convertible into a COM add-in without too much trouble, though you should
follow the examples to make the menu hooks work right, etc.
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.