631 karma · joined August 23, 2016
However, I have this to say about Excel. MicroSoft is making a push to kill VBA with two prong. One, replace VBA with JavaScript through OfficeJS. Two, beef up Power Query and Power Pivot so that you can do enough ETL in Excel through a point and click interface.
But the nasty truth is that on the ground in offices worldwide, there are ETL flows that shouldn't exist, but middle managers do not possess the political capital, incentives, or technical skill to remove. And while Power Query, M, DAX and Power Pivot are excellent, in, let's say, 5% of workflows, you need some business logic in some language that is more flexible. And this is the real problem with VBA; it papers over dirty workflows, even if the data structures you are provided are not good.
Thanks!