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

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.