We have a spreadsheet that takes information from online orders into input cells. Then it has lines that if they calculate a qty of 1 or greater get consumed by CAM software. The product then gets sent to the appropriate machining center. Not a single line of VB. There are a few things that I could extract into custom formulas that would remove pages and pages of Excel formulas. However the entire point of the Excel setup is so that product experts not programmers can edit them.
We currently have F# in our internal tools. We have a couple of CRUD apps on the SAFE stack. A few ETL tasks in F#. The bug count seems to be much lower when using F#.
There is some legacy stuff in PHP, JAVA and C#.
Then we have an online store in C# but that is just using an open source tool NopCommerce. I couldn't recommend that highly enough. It has been amazing compared to everything I've worked with in the past.
But this would never fly for us. The pricing model could not be sold to management.
What would work is if it was something like $5k for a year of updates. We're on 365 so office's constant updates would force us to upgrade every year. But management would not feel like they're renting something they would rather own.