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 a pretty straightforward activity. Just emulate a few VBA functions and do a little tweaking.
It was kind of tough
In any case, I am nearly done, and above is the output. Not quite as nice as the Excel version, but it will do for now. Barring a few formatting cleanups, it’s largely done.
It’s been a lot tougher than I had hoped, and I am pretty disappointed at the performance issues, and the missing capabilities. Nevertheless, I now have a very large library of ‘VBA like’ functions that will make future conversions pretty straightforward.
In addition, the sharing and permissions model is almost incomprehensible and I think that those of you that are used to sending spreadsheets around with embedded macros will pull your hair out.
Don’t give up on VBA yet…. You can read the full story and get the code here – From VBA to Google Apps Script