I only recently became aware of Google Moderator. It’s a very simple tool to get sentiments on topics, ask questions, get suggestions and so on. If you have a Google Site, it’s very easy to […]
In a previous post I covered how to navigate REST responses using a simple treeview control as well as how to create a Treeview from any jSon object in a few lines of code. Recursion […]
If you open an Office Document, you might occassionally find your self with an error that tells you that your “object library is invalid” , “excel has had a catastrophic failure” or you have an […]
In a post the other day i covered how to use the scriptcontrol to call javaScript directly from VBA. Considering that javaScript has plenty of useful methods for manipulating arrays and strings and so on […]
Those of you that read this blog, and the ramblings site, will know that the topic content is about equally split between VBA and javaScript. Until today, I had no idea that there was a […]
Yesterday, I showed how to get all the f1 circuit names and locations using the Ergast API along with the Rest-Excel library. Now we have that data to play with, why not visualize them on […]
Thanks to Tony Hirst blog, where he demonstrates the Ergast API I have another entry to make in the Rest-Excel library. This time, it’s all the F1 races to start with, along with the possibility […]
If you are working with Google Apps Script, one of your priorities is definitely going to be a simple timer. Everything takes longer than you are used to, and you have to be very careful […]
I got this idea from Tony Hirst’s great blog. The OpenCorporates API gives rich information many companies. Using Google Refine to reconcile, it cleans up many sources of data to a queryable datasource. So here […]
There are many Google Mapping Examples in the Excel and Maps Integration section of the Ramblings site. So much so that it can be quite hard to get started in a small way. There is […]
For those of you that have been following VBA to Google Apps Script, here is another one. This time, it’s a conversion of the Excel color ramp library. You can download the code for and […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines