It is great that particular tools enable employees automate stuff and make their work more effective.
From developer point of view I see that the effort would most certainly be diverted in another kind of solution.
But yeah, "citizen developer" stuff is a thing that microsoft pushes especially in Power Platform / Canvas Apps - one programs with WYSIWIG and Excel-like formulas (PowerFX)
But then again I wonder who are the people that can program in VBA and chooses excel. Is it the constraint around software they can use? An excel being a GUI which you don't have to implement? Anyways, a net positive for business.
I'm sure the free GUI is the gateway drug, but at this point practically everybody in finance uses Excel. You can pass files and scripts around and be pretty confident that the external auditor will be able to use them.
From developer point of view I see that the effort would most certainly be diverted in another kind of solution.
But yeah, "citizen developer" stuff is a thing that microsoft pushes especially in Power Platform / Canvas Apps - one programs with WYSIWIG and Excel-like formulas (PowerFX)
But then again I wonder who are the people that can program in VBA and chooses excel. Is it the constraint around software they can use? An excel being a GUI which you don't have to implement? Anyways, a net positive for business.