Snippets

Getting Started with argument passing

What can you learn here? Argument passing ByREF versus byVAL Optional and variable arguments     Argument passing Nowadays passing arguments to procedures is intuitive and the mechanics of how that happens is mainly the […]

No Picture
Apps Script & Java Script

Asynchronicity and Scheduling

What can you learn here? Timers Scheduling tasks Progress bars Dealing with asynchronous events VBA has Event Processing capabilities. This is how it is able to deal with mouse clicks, form events and so on. […]

Apps Script & Java Script

Google Apps Script snippets

There are many Google Apps Script projects and snippets scattered around this site. I’m going to try to organize them in this page, but it will take a while. If you find something on the […]

No Picture
Apps Script & Java Script

Null should mean something

It’s a common pattern in JavaScript to do this to assign a default value to a variable : var theThing = someThing || defaultThing; In other words, if someThing has a ‘falsey’ value (false, null […]

No Picture
Sheets specific

Are the new Google Sheets faster than the old?

In December, Google released new Sheets, saying they are faster and better than the old – including working offline. I’ve made a couple of tests to compare the old and the new – a simple operation […]

Apps Script & Java Script

Publish and prettify source directly from a url

If you’ve been following the various posts about publishing source code from gists, google apps script, scriptdb and so on, you may have realizes there was one missing link. Publishing source code direct from a […]

Apps Script & Java Script

Publishing Google Apps Script code snippets

In a previous post I showed how Google Apps Script could return the contents of a script as Json so you could format that for including script samples on web sites. Today, here is how […]

No Picture
Apps Script & Java Script

Google Caching and faking jsonp

In using Google Apps Script as a jSONP proxy, I covered how you could use GAS to get over javaScript same domain restrictions. If you need to access jSon data from javaScript, jQuery and so […]

No Picture
From VBA to Google Apps Script

Rest Library for Google Apps Script

In previous posts I covered a couple of conversions of Excel VBA projects to Google Apps Script, with particular emphasis on maintaining compatibility between the solutions to allow for dual maintenance. Previous conversions have been a GAS […]

No Picture
Javascript

Using JScript inside VBA

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 […]