Is there any way to run VBA script & Excel formula and receive results via API response ?

Question

I have an Excel file that I use in my business, which outputs results based on information entered into an Excel sheet through a complex calculation process using VBA macros and Excel functions.

I would like to exchange the input and output information of this file via API and receive the processing of the Excel file via HTTP.

For this purpose, I am imagining a structure in which Excel is operated on a GUI like PowerShell in a VM environment, an API server is set up, and the PowerShell program is executed via the API server.

If there is any other modern mechanism to manipulate the input/output of an Excel sheet with embedded VBA macros and Excel formula, please let me know.

Thank you