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
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
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
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
Public Function gtExampleLoad() ' we are going to need cStringChunker gtDoit "5152181" End Function
ParseCom API
Public Function gtExampleLoad() ' also needs cJobject and cDataSet gtDoit "7663169" End Function
Instrumenting VBA for Google Analytics
Public Function gtExampleLoad() 'uameasure gtDoit "7471153", True End Function
Charts and color ramps
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
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
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 FunctionFor help and more information join our forum, follow the blog, follow me on Twitter