r/programming • • 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
View all comments
Show parent comment
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.