What can you learn here?
- Using ramblings libraries
- Short code snippets
- Abbreviated explanations
Complex stuff in a few lines of code get it now
This section is going to cover how to do complex stuff in just a few lines, mainly using the classes and modules you can find in the cDataSet.xlsm (or the Google Apps Version), which you can download here. In many cases you may not actually be using these classes, just leveraging some of their inbuilt properties and methods. They probably wont be exactly ‘one liners’, but pretty close.
You may need some additional VBA references, all of which are defined in the cDataSet.xlsm file. If you use that, all the references are already defined.
- Getting data out of scraperWiki
- Excel to Json and output to file
This class is used to store data from user forms in a hidden shape to make it persistent from one use to the next.