Google Apps Script equivalents for common VBA functions

As part of creating a framework for dual maintenance of Google Apps Script and VBA versions of the same application, one of the key things was to produce a set of functions in GAS that would be equivalent to the most common ones in VBA. This includes various objects missing from GAS such as the VBA collection.

Here is a selection of the GAS equivalent of common VBA functions. For more like this, take a look at the ramblings site, or contact me on our forum.

Strings

User Interaction

Conversion

Informational and general

 

About brucemcp 223 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

2 Comments

  1. This is a great resource for people converting from Excel to Google spreadsheets. It would be great if you could publish this set of functions to the script gallery, to make it easy for people to use them in their spreadsheets.

Leave a Reply

Your email address will not be published.


*


eighteen + 14 =