4 ms·
FWIW, I think JavaScript is an awful language as well, just for different reasons than I dislike VBA. VBA in my experience has too many quirks that can't be wr
by blincoln 3y ago
FWIW, I think JavaScript is an awful language as well, just for different reasons than I dislike VBA.
VBA in my experience has too many quirks that can't be wrapped in a less-quirky general purpose function. For example, I was just working in Word and was reminded that as soon as tables come into the mix, the order of text in the document is no longer linear in terms of numeric range values. E.g. text might have a greater numeric offset value in the document than text that visually appears after it, if the first text is inside a table. I've had Word VBA get confused about this, and extend a search loop outside the range I gave it to search within and start returning content in other parts of the document. Why would I trust a language like that for anything important?
MS should really have just gone forward with a .NET replacement, IMO. C# is one of the best things they've ever invented.
- mcbishop 3y agoI hear you. Wrapping stuff in less-quirky functions... is a slippery slope to building a framework with a new object model (on top of the current object model). With that said, I love the hell out of VBA.