Heenan, Lambert
Lambert.Heenan at AIG.com
Thu May 3 13:47:03 CDT 2007
I'm on Charlotte's side with this one. :-) A "library" is a grouping of executable code which can be linked to or have references set to and the code within becomes available to the client application. No cutting and pasting involved. The point being that the code in question is immediately usable by the client once the linkage has been established. There's also no cherry picking of code routines to make available. Link to a library and you get it all. Typically, whenever a library file is modified in any way all the client applications need to be recompiled as the references/jump tables (or whatever else is used behind the scenes to define the code entry points) will have changed. "<snip> Access is the ONLY Office application that allows libraries but they are indeed libraries. <snip>" I can't agree with that statement either. I can put a bunch of code modules into an Excel file, and in the VBA IDE I can set the project name to something other than "VBAProject". After I save the Excel file I am then able to set a reference to it in another Excel and the (public) routines in the referenced file will be available for use. I have a library. Lambert