In How to update modules automatically in VBA, you can see how to add and update modules from github directly in VBA. This post on the Excel Ramblings blog, will take you through a step by step example.
Most code on this site can be found in either cDataSet.xlsm or googleMapping.xlsm which are also available in the downloadable page here, but the problem with that is you end up with a bunch of stuff you don’t need in your workbook, and it’s difficult to update later with bug fixes and new features.
So now we need a reference list for how to get various pieces of code into your workbook. Once you have followed the instructions for IDE access and installed the gistThat_ module you can create a procedure or run these in the immediate window. They can be run at anytime to get updates. They will also add the required references to your project. I always recommend running on a blank workbook the first time to ensure that everything compiles in your environment. Note that these add just the libraries, not the examples – you should get any examples you need from cDataSet.xlsm or googleMapping.xlsm
Here’s the code to get various families of classes, modules and references from github. Note – the 2nd argument (true) is only required if you already have some of these modules that have not previously been loaded by gistThat – it allows the overwriting of modules not being maintained by gistThat. After the 1st load you can drop it.
Note – I have also implemented a direct VBA to GIT capability which I tend to use nowadays instead of this – see Integrate VBA with Github
cDataSet
1 2 3 4 5 6 |
Public Function gtExampleLoad() ' we are going to need cDataSet and cjobject stuff as well gtDoit "3414394" ''--- or use gtDoit "3414394", True (if doing it for the first time) End Function |
cJobject
1 2 3 4 5 6 |
Public Function gtExampleLoad() ' we are going to need cDataSet and cjobject stuff as well gtDoit "3414394" ''--- or use gtDoit "3414394", True (if doing it for the first time) End Function |
Rest to Excel library
1 2 3 4 5 6 7 8 9 10 11 12 |
Public Function gtExampleLoad() ' we are going to need cDataSet and cjobject stuff as well gtDoit "3414394" ' and crest gtDoit "5055578" 'uameasure - if instrumenting. gtDoit "7471153", True End Function |
Strings and garbage
1 2 3 4 5 6 |
Public Function gtExampleLoad() ' we are going to need cStringChunker gtDoit "5152181" End Function |
ParseCom API
1 2 3 4 5 6 |
Public Function gtExampleLoad() ' also needs cJobject and cDataSet gtDoit "7663169" End Function |
Instrumenting VBA for Google Analytics
1 2 3 4 |
Public Function gtExampleLoad() 'uameasure gtDoit "7471153", True End Function |
Charts and color ramps
1 2 3 4 5 6 7 8 9 10 11 |
Public Function gtExampleLoad() ' this is an example of how you would load your VBE with a particular manifest ' you could set the 2nd parameter to overrride conflict checking the first time used- ' we are going to need cDataSet and cjobject stuff as well gtDoit "3414394" ' and useful chart stuff gtDoit "5211832" End Function |
Automatic documentation
1 2 3 4 5 6 7 8 9 |
Public Function gtExampleLoad() ' this is an example of how you would load your VBE with a particular manifest ' you could set the 2nd parameter to overrride conflict checking the first time used- ' cdataset gtDoit "3414394" ' and class serializer gtDoit "5028829" End Function |
pinyin marks to and from tone numbers
1 2 3 4 5 6 7 |
Public Function gtExampleLoad() ' this is an example of how you would load your VBE with a particular manifest ' you could set the 2nd parameter to overrride conflict checking the first time used- ' we are going to need cDataSet and cjobject stuff as well gtDoit "6415598", True End Function |