Comment by thewebguyd
20 hours ago
> Excel is a highly used tool possibly the most used tool and enables many users who do not consider themselves programmers to be productive with their PCs.
What frustrates me the most about this is I've seen some insane excel wizardry from the accounting department at various jobs over the years that is effectively programming, and that if these people had put just as much effort into learning Python & using a database, they'd be better off and might actually make good developers. In my view, Excel ends up becoming sort of an artificial barrier to departments outside of IT being able to make business software.
Also a good point- but there is no python runtime on accounting and PMs computers. And it’s also a huge mess to try and support. Imagine some python code from 10 years ago, then juggling the versions, then god forbid any module dependencies. It’s simply not portable. Meanwhile the VBA written in 2000 is still working all contained in an excel Workbook.
Now let's talk about MS Access!