Module reference list

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 downloadable 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

Public Function gtExampleLoad()

' also needs cJobject and cDataSet
  gtDoit "7663169"
  
End Function


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 Function
For help and more information join our forumfollow the blogfollow me on twitter

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, All formats are available from O'ReillyAmazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.


Comments