cOauth2 class implementation

In Google Oauth2 VBA authentication I showed how to use this class. All associated libraries are available in the cDataSet.xlsm library downloadable here,  or through gistthat, as described here. You'll need the cRest module.


Here are some of the examples referred to in Google Oauth2 VBA authentication


A wrapper function is provided for access to the cOauth2 class. For now, only the Google Oauth2 is implemented. 

cOauth2 class


This uses the CAPICOM object for DES encryption, which is only supported in Excel 32bit. Excel 64 bit is not encrypted

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, available All formats are available now from O'Reilly,Amazon 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.