Accessing parse.com and scriptDB noSQL databases from Excel
I figured it would be pretty nice to be able use one of the cloud based noSQL databases directly from…
Dealing with Unix timestamps in Excel
If you take data from outside Excel – especially using REST APIS, there’s a good chance that you’ll have to…
Encryption/decryption library for Google Apps Script. Amit Agarwal recently showed how to encrypt/decrypt Email messages using a Google Apps Script…
Tracking your Excel Workbooks with Google Analytics
Last week, I posted how to instrument Excel workbooks so that usage of them could be tracked using Google Analytics….
Mitigating for changes in REST API rules and formats
In Rest-Excel library, I have examples of a large number of REST APIs which get data from a wide range…
XML and JSON conversion in VBA
If you are familiar with this blog and the Excel Liberation site, you’ll know that there is a pretty significant…
Excel custom functions that can lookup data in Google Apps Script ScriptDB
In REST access to Google Apps Script list management functions we looked at accessing the Google Apps ScriptDB and some custom functions…
REST access to list management cloud based functions – plus a VBA example
In Google Apps Script lists and validation I showed how to use custom functions from Google Spreadsheets to perform common spreadsheet…
When the scriptable data validation feature in Google Apps Script came out recently, I started thinking about how we don’t…
Pinyin Tone converter – Google Apps Script custom functions
I’ve never been shy of writing up something I don’t know much about, and today’s post is no different. A…
What does Google Autocomplete show all over the world ?
It turns out there is a kind of API – suggestqueries.google.com – that you can use to programatically get what Google…
Google Docs to Excel Asynchronously
I’ve been playing around with creating a promise based framework for VBA for a while now, mainly just to see…