How can you say that? I give companies SAP like functionality for $150,000 instead of $5,000,000.
I don't think you understand the power of the VBA.
But technical folks like the complexity of technology. Job security.
Because the language sucks.
I don't think you understand the power of the VBA.
I fully understand the language, which is why I know it sucks. It's old and antiquated, no matter how much they tack on it to keep it alive. You can use C# to access Office objects too. Try that and you'll thank yourself, especially if you ever do any array or list handling (which, if you work with Excel, you probably do); generics lists are especially sweet. You'll probably get much better performance too.
But technical folks like the complexity of technology. Job security.
It's the same tool, Visual Studio. It's the same application suite, Office. You just choose C# application instead of VB application when you create your project. Then enjoy the world of a newer object-oriented-from-scratch language vs. an anachronism from the early 90s.