PyXLL is great but installing on users machines can be difficult. The problem that VBA actually solves in my opinion is that it allows technicalish users to build software without any controls. Most enterprise companies lock down the dev experience so much it is impossible to do anything but in VBA you can have direct access to the kernel.