[AccessD] Modules and libraries in Office

Charlotte Foust cfoust at infostatsystems.com
Mon Nov 8 16:04:35 CST 2004


Didn't aPress buy some of them as well?

Charlotte Foust


-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Monday, November 08, 2004 1:42 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Modules and libraries in Office


I think Wiley bought some of the books and the trademark.  The book I
worked on still sells.

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 Jim Lawrence
(AccessD)
Sent: Monday, November 08, 2004 4:00 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Modules and libraries in Office


WROX is gone?!! :-(  Just bought one of their VB.Net books.

I have so many of their books around here I feel like an advertisement.
There must be thousands of their book currently in the system as many
local bookstores still have many of their books on their shelves.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Colby, John
Sent: Monday, November 08, 2004 9:49 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Modules and libraries in Office


LOL.  You know the old saying "Its not what you know but who you know.".

Martin gave my name to Wrox.  I worked on one book for them then they
went bankrupt (hopefully through no fault of mine!).  Pieces were bought
by Wiley including the book I worked on.  They then contacted me about
another project.

I want to do my own project though.

John W. Colby
The DIS Database Guy


-----Original Message-----
From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca]
Sent: Monday, November 08, 2004 12:30 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Modules and libraries in Office


How many book writers does that make within the list? An impressive
group of individuals.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Monday, November 08, 2004 4:36 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Modules and libraries in Office


I am proposing a book to a publisher I just finished writing for, which
will be about reusable code for Microsoft Access specifically, modules,
classes, libraries and frameworks.

I was hoping to find a way to make the code accessible to different
platforms should someone be more comfortable working in Word or Excel.
While a com object would certainly accomplish this, it involves tools
(and
expertise) outside of the office suite.

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 11:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Modules and libraries in Office


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
>

--
_______________________________________________
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

-- 
_______________________________________________
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