What programming language to choose for the project instead of Excel VBA?

Question

Visual Basic

Hello!
We have a certain product in our company - a network economic strategy for 30 people, working on a local computer, written in VBA (a full-fledged client-server). The product is non-commercial, exclusively for internal use.
Now the question is about translating this whole thing into the web. I more or less figured out the frontend and put a template on the bootstrap with which we will work, but I can’t decide on the choice of jap / framework for the backend - as I started to study the topic, my eyes run wide - php, java, python, lua .. How to most painlessly transfer the
project to another technology stack, given that the project will be studied from scratch to implement the project (I only have experience in VBA and a little HTML / CSS)?
The project has a lot of calculations and formulas, if you can organize them as easily as in Excel, using tables, it would be generally cool.

Answer 1

PHP is the fastest and cheapest. But you can try in python if you want to learn it.

Answer 2

Maybe VB.NET on the ASP.NET platform?

Answer 3

(It is not said why it is impossible to leave the back on VBA. It looks like it is optimal.)
An analogue (one of) Excel is Google. All tabular calculations are exported there. This is already, apparently, a big piece in your case.
Google App Script itself generates HTML from a template. VBA -> GAS is pretty straightforward. + Native cloud goodies such as authorization, mail processing, etc. are implemented in GAS.
How have you been since April?