Utility libraries form the core of all my applications.
Once I have written and tested a small VBA procedure that is perceived to have mutiple uses, I store it in a libraru of source code that can be used by other applicatons.
A good example is my set of procedures that manipulate INI files. general-purpose code to read and write application parameters to a text file are of obvious use to most applications. Once the two procedures strGPA and strPPA are tested, into the library they go. the next application that needs to manager its own parameters merely places a call the the well-tested procedures; I do not have to re-write them.
The Word Utility library UW.DOT holds 818 such functions at last count.
That’s a lot of power, and it helps to explain why my application development process is so fast and streamlined (and low-cost)
There is a similar, though not as extensive, library UX.XLA for my Excel applications.
