3 ms·
But unfortunately microsoft didn’t invest into VBA in 20 years, other than keeping the light on. And it lacks so many modern features. There was an attempt at
by cm2187 3y ago
But unfortunately microsoft didn’t invest into VBA in 20 years, other than keeping the light on. And it lacks so many modern features.
There was an attempt at a .net version of VBA (would have worked the same way, with a mini visual studio embedded in Office), called VSTA. But it was killed. So the cattle (business users) is stuck with 1990s technology.
- steve1977 3y agoMaybe that turned out to be more of a strength than a weakness?
- cm2187 3y agoA strength for whom? Not the end user.
- mcbishop 3y agoIt depends on the user. I use the basic VBA components to build my own features (exactly how I want them). I'm happy that Microsoft isn't meddling.
- cm2187 3y agoThe lack of basic functionalities like generics, sort functions, lambdas, is a hinderance if you got a taste of .net.
- mst 3y agoIt's a hindrance to -us- but I suspect for code that's designed to be passed from SME to SME that -not- having access to features so you have to write things the ugly stupid way ... may actually be an advantage, since the next SME along only has to have a sufficient tolerance for 'ugly' rather than an understanding of the features you and I would both want.
- mcbishop 3y agoSorting is fine in VBA. But, I admit, it'd be sweet to have lambdas.