[AccessD] Modules and libraries in Office

Michael R Mattys michael.mattys at adelphia.net
Sun Nov 7 22:08:34 CST 2004


Maybe I'm misunderstanding, but ...

(From Q230225)
COM add-ins are a new feature in Microsoft Office 2000
and are supported by all Office programs, including Outlook.

Key benefits of COM add-ins include:

COM add-ins run in-process with the host program, so custom
code generally runs faster than code implemented in Visual Basic
for Applications.

The basic COM add-in architecture is consistent across all Office
programs, whereas in previous versions of Office, each program had
its own add-in architecture.

You can create one COM add-in to use with more than one Office program.

Example:

http://support.microsoft.com/kb/238228

----

Michael R. Mattys
Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com



----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Sunday, November 07, 2004 10:46 PM
Subject: RE: [AccessD] Modules and libraries in Office


> No, I'm talking about an application framework where the code is available
> to any Office application.
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R
Mattys
> Sent: Sunday, November 07, 2004 10:16 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Modules and libraries in Office
>
>
> John,
>
> Are you talking about the designers?
>
> I thought you could have a common standard or class module within the dll,
> and just pass in the Application object as Object. Then just Select Case
to
> perform the appropriate action. I'll look again, but I'm pretty sure
that's
> it.
>
> ----
>
> Michael R. Mattys
> Mattys MapLib for Microsoft MapPoint http://www.mattysconsulting.com
>
>
>
> ----- Original Message ----- 
> From: "John W. Colby" <jwcolby at colbyconsulting.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Sunday, November 07, 2004 8:36 PM
> Subject: RE: [AccessD] Modules and libraries in Office
>
>
> > Holy cow, is that a mish mash or what?  The point of my questions was
> > to
> try
> > to find a common ground where code could be stored and run from all of
> > the various office applications.  Not to be it would seem.  It does
> > seem
> bizarre
> > that if I had some function that should be able to run in any of the
> > apps
> I
> > have to save the same thing in 5 different places so that Access,
> > Excel, Word, Powerpoint and Outlook could use it.
> >
> > John W. Colby
> > www.ColbyConsulting.com
> >
> > Contribute your unused CPU cycles to a good cause:
> > http://folding.stanford.edu/
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > MartyConnelly
> > Sent: Sunday, November 07, 2004 2:03 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Modules and libraries in Office
> >
> >
> > In Excel you can store functions and modules as Public in .xla  files.
> > Old Excel pre 97 didn't store the code in xla it looked like an mde
> > file. Matter of fact you can call these .xla files from Access. I have
> > called functions from the Excel Statistical and Financial Analysis
> > Packs.
> >
> > In Outlook 2000  and any code that you create in the Outlook VBA
> > environment is stored in a file named VBAProject.otm. Even though you
> > can copy the VBAProject.otm file, that's not a good way to distribute
> > Outlook macros company-wide. The recommended method is to create an
> > Outlook or Word  COM add-in. Talk to Shamil he has been upgrading com
> > addins to dotnet. http://www.outlookcode.com/d/vb.htm
> > http://www.outlookcode.com/d/comaddins.htm
> >
> > Word uses templates either user or workgroup (to be shared) in a
> > specific folder A template  contain macros or other customizations
> > such as toolbars, it works better from some locations than others.
> > Again these com addin's can be used in place of macro's.
> > see
> > http://word.mvps.org/FAQs/index.htm
> >
> > Just for future reference this method is also partially available
> > under word and excel
> >
> > Under the Tools/References menu in the VBE, you need to check the
> Microsoft
> > Visual Basic for Applications Extensibility 5.3 object library.
> > Microsoft Visual Basic for Applications Extensibility 5.3 C:\Program
> > Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
> >
> >
> > The following code exports the contents of the Code Module to a file
> called
> > test.bas. This can be run from Word or Excel
> >
> > Application.VBE.ActiveVBProject.VBComponents("Module1").Export("test.b
> > as")
> > I think you can also import code this way but never tried it or got it
> > to work or something.
> >
> > John W. Colby wrote:
> >
> > >In Access we use MDA/Es to store libraries of reusable code.  Is
> > >there an equivalent for Word / Excel / Outlook etc (the rest of
> > >Office)?  Do these other platforms have references like we do in
> > >Access?  If so, can you reference an MDA/E to use code in it?
> > >
> > >John W. Colby
> > >www.ColbyConsulting.com
> > >
> > >Contribute your unused CPU cycles to a good cause:
> > >http://folding.stanford.edu/
> > >
> > >
> > >
> > >
> >
> > --
> > Marty Connelly
> > Victoria, B.C.
> > Canada
> >
> >
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list