Today’s post is about how to use the jSon to treeView capability in a previous post, and apply it to explore results returned by Rest- Excel library. The library, itself a jSon structure, is visualized […]
Back to the theme of ‘do it in one line’ today. Thinking about some the jSon – Excel capabilities on the ramblings site , and the structure of the cJobject class in which they are […]
On the ramblings site, you will find lots of downloadable examples and explanations dealing with connecting Excel to Google Maps and Earth. Following numerous requests on our forum, here’s how to filter google markers according […]
Conversion effort A few weeks ago I wrote about starting my effort to convert a complex VBA project to Google Apps Script. I vaguely remember thinking at the time that this was going to be […]
In a previous post, I introduced the concept of local caching of Google Docs Spreadsheet Values to be able to optimize Google Apps Script without needing to change the structure of your code. This gave […]
It’s well known that reading all the values at once from a Google Spreadsheet is much more efficient than doing it one by one. You can work round this if you are starting from scratch, […]
Lets say you have an Excel workbook consisting of tabs, all in the same format, that various people completed. You want to copy them all to a consolidated sheet from time to time so you […]
You are ready to move to the cloud, but what about all those legacy vba apps? Are they really going to influence your decision such that you have to stay where you are? Moving to […]
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