Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

If you have a Microsoft 365 subscription, you can access Python within Excel, and you don't need to use Python as a separate app. Instead, you can visit the Formulas tab in Excel and select the Insert ...

With this new feature, users can type in Python code in the Excel app. The calculations are then run on a Microsoft cloud server and are returned to the Excel app, with plots and visualizations.