I myself used Excel for many years. Formerly a management accountant, I can say that Excel is everywhere and is a first choice for anything if there is no proper application to do the job. I have written many macros/VBA, created applications in Access, SQL and some proper database apps also. Excel will not go anywhere. The users are business people, and they have to do their job on the short term. Unless there is an ERP implemented(or any app) that covers their respective area, things are going to remain in Excel. Their job differs from that of a programmer: they execute the business processes like check invoices, send emails to suppliers, customers, calculate costs... mostly in Excel, and maybe for the main issues, in their core ERP system (SAP or Oracle etc). The question is if the management recognizes the need to avoid this Excel hell, and build some additional tools or integrate the processes better in their ERP. But often the ERP related decisions are taken on a much higher level than the operational level, and only things with global impact are implemented. So the solution is to produce some mid level (factory, location, business unit) apps/tools that can manage the respective process.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I myself used Excel for many years. Formerly a management accountant, I can say that Excel is everywhere and is a first choice for anything if there is no proper application to do the job. I have written many macros/VBA, created applications in Access, SQL and some proper database apps also. Excel will not go anywhere. The users are business people, and they have to do their job on the short term. Unless there is an ERP implemented(or any app) that covers their respective area, things are going to remain in Excel. Their job differs from that of a programmer: they execute the business processes like check invoices, send emails to suppliers, customers, calculate costs... mostly in Excel, and maybe for the main issues, in their core ERP system (SAP or Oracle etc). The question is if the management recognizes the need to avoid this Excel hell, and build some additional tools or integrate the processes better in their ERP. But often the ERP related decisions are taken on a much higher level than the operational level, and only things with global impact are implemented. So the solution is to produce some mid level (factory, location, business unit) apps/tools that can manage the respective process.