MS used to have a product called Code Librarian that shipped with
the Developer's Edition of Office, which allowed you to organize
source code in a central library. This was a source code
organizer; you couldn't directly run the code in the library, you
cut and pasted in to host applications. I don't know what
happened to Code Librarian, I don't think it ships in any version
of Office 2003.

You could create an ActiveX DLL (using VB6) containing all your
common code, and then instantiate that object in your host
applications.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Maury Markowitz"
wrote in message
...
We have a lot of code that is essentially "universal", that is,
it could
easily be run in Excel or Access. In fact the vast majority of
our code is
like this, we use the applications largely as a display system.

Is there some way to isolate this code into a stand-alone
library of some
sort, and use it in any application we choose? If we want to
use it in Excel
we have the .xla, but I don't see a format that can be used for
Office app?

Maury