Appendix A, provisionally entitled "Appendix A: Excel VBA And Google Apps Script Comparison"
has been added to my book Google Spreadsheet Programming
Download the free sample which includes the appendix covering common spreadsheet programming tasks in both VBA and Google Apps Script.
Please send me any comments or suggestions that you have so that I can add to and improve the material it contains. More content will be added in due time.
Some Notes On Google Apps Scripts and VBA
The most common type of request that I receive from readers is how to translate Excel VBA into Google Apps Script. Google Spreadsheets implements most of the standard spreadsheet functions in addition to a few of its own. However, from a programming perspective Excel and Google Spreadsheets are quite different:
However, both languages are hosted within applications and are used as the "glue" to integrate applications. Their APIs are therefore quite similar in philosophy if not in detail.
Check out the PDF and let me know what you think!
I'm getting positive feedback on this blog entry so there is clearly some interest in this. Accordingly, I will continue to update the PDF with additional code examples. Suggestions or examples are also very welcome!