So here is the Technical Function library:
schTechLIB can be downloaded here as a zip file.
- [21/11/2013] Original
- Sun 2013-Nov-24 13:25 : Converted global constant (MtrlDB) to a user defined function which builds the path to the MS Access materials database from information stored in a worksheet (AppEnvVar) in the ActiveWorkBook. Whilst this provides some user flexibility, the drawback is the calculations show #VALUE! when the calculation workbooks don't have focus. I been considering creating a configuration file for a while, just not certain whether to use xml, or xls file formats, or whether to store in the Tech Library itself. It seems xml could give me problems if people don't have the same version of xml driver installed on their machines. On the other hand I move between Excel and Access, so I prefer code which works in both applications with out need to call the other application. Also prefer code which stands alone with out use of any MS office product. So approach taken is a quick fix to solve current problem. Users can redefine MtrlDB to return a fixed path without reference to activeworkbook.
- [23/04/2016] Changed download links to point to MiScion Pty Ltd Web Store