A class module for reading configurations

[RossSharma]

Hi,

I created this module years ago and it has been a staple in all my projects since. I'd like to share it with you all.

Basically, it allows you to put configuration settings on a sheet, and read from the sheet. Your configurations can be single values, tables, or even cell formatting.

This makes it possible for developers and end-users alike to manipulate configurable settings easily, without manipulating code.

It also has some features such as caching (for performance boost), and overriding values with test values.

A very basic use case:

Please Login or Register  to view this content.

Please take a look at the demo video:
http://youtu.be/OpvZwZR9uRs

And download the demo file (Excel 2003 and later):
https://docs.google.com/uc?authuser=...xport=download


Code is on GitHub:
https://github.com/ross-sharma/excel-vba-settingsreader

[shg]

That's very cleverly conceived, and the video is well done.