Re:The worst of the two worlds: Excel meets Outlook
by passivate on Sunday February 14, 2021 @09:14PM
(#26138300)
Oh, I was mainly interested in your view to kick off a conversation. I wasn't sure what you meant by long detours. I don't program in VBA, so I was interested. From the outside, it seems like a powerful language for non-programmers to implement business logic.
Re:The worst of the two worlds: Excel meets Outlook
by airstrike on Monday February 15, 2021 @12:11PM
(#26144652)
Sorry, didn't mean to sound rude at all. I guess I was a bit on the defensive given all the pushback I was getting elsethread
It's hard to really pin it down to a couple of things, but after spending some time in it, you quickly feel the ergonomics aren't really great. It's just a lot of typing to get basic things done like inserting an element into a 1-d array.
For such a high-level language and one directed at non-programmers as you mentioned, you'd think that sort of tooling would be available natively
http://www.cpearson.com/Excel/VBAArrays.htm
Imagine how painful your experience would be writing any decently complex reusable code in VBA without knowing about all of the edge cases covered by Chip in that module