We are currently working with an Excel spreadsheet + VBA for automated processing of our online orders. The VBA script scraps the data from our wordpress/woocommerce store, enters it into the spreadsheet, mails the orders to the suppliers, puts the mail in a folder on the server, updates order statuses and exports data for accounting. In the future, these operations should be performed not by VBA, but with the help of Office Scripts [login to view URL] and Power Automate, so that we can work with the table from MS Teams.
The VBA scripts are all viewable and can be used as templates. However, it would be desirable that the developer not only adopts the code 1:1, but also critically scrutinizes it and makes suggestions for improvement.