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 ...

Some members of the Microsoft 365 Insiders program can now try out the combination of Python, Excel and the Anaconda Python repository.

Users will be able to enter Python code directly into cells using the new =PY function, as Python will be integrated directly into the Excel grid, with no need to install additional software.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.