Maggie asks what I use for a code library. Sadly, nothing. When I need a piece of code that I’ve used before, I go find the project where I used it and copy it out of there. The success rate on that method is about 70% – success meaning that I find what I’m looking for in a reasonable amount of time. Ten percent of the time I never find it, and basically start from scratch.
The final 20% constitutes finding it in an unreasonable amount of time. When that happens, I copy it in a blank workbook and save the workbook with a really long, descriptive name so I can find it the next time.
I have the developer addition of MS Office, which I believe ships with a code library, but I don’t know where it is, so maybe I didn’t install it.
Also, since I started this blog, I’ve been adding code to this category, VBA Code Library. I reuse a lot more code than what’s here, however, because I’ve constrained myself to putting ready-to-use code here. A lot of the code that I reuse isn’t quite general or self-contained enough that I feel comfortable publishing it. Ultimately I’d like to have this category be my only source for reusable code. I just need to figure out how to present that code that’s not in a copy-and-run state.
Well, it must be Friday because I’m giving you nothing and instead asking you for something. What do you use as a code library, if anything? How self-contained is the code in your library? Is there a benefit to having a code library on the web?