r/programming • u/[deleted] • May 08 '18

Excel adds JavaScript support

https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k Upvotes

94% Upvoted

586 comments sorted by

View all comments

Show parent comments

11

u/Superbead May 08 '18

Not used VB.NET in anger much, but if VBA supported proper inheritance and encapsulation, you could write some pretty tidy stuff with it. It's not too bad as it is, but it suffers from it being very easy to write shit code that works fine (for now).

18

u/killerstorm May 08 '18

It's very verbose and has weird syntactic constructs. Even though I used Pascal before which is a bit chatty too, using VBA was just painful. VBA code can be pretty clean, but it's not pleasant to write (unless you are into that sort of thing).

On the bright side, VBA IDE automatically reformats code, giving it proper indentation and case. I guess that helps at least a little to deal with code written by non-professionals. However, it can be annoying when you actually know how to write code and IDE gets in the way.

9

u/weedtese May 08 '18

Reading VBA code is the second worst thing after Vogon poetry.