Excel now has two scripting languages: VBA and Python. Key comparisons:
Usage
Built-in Python: Formula-based (similar to Power Query’s M language).
VBA: Has a full script editor.
Data Handling
Built-in Python: Supports pandas (designed for large data)—handles large datasets easily; also works for small/medium data.
VBA: Best for small/medium data; struggles with large data.
Functionality
Built-in Python: Supports 20+ packages (pandas, matplotlib, scikit-learn, etc.)—enables statistical analysis, machine learning, symbolic computation, and more.
VBA: Limited to traditional Excel tasks.
Will Python Replace VBA?
Yes. Python’s functionality (via pandas, xlwings, etc.) already matches/exceeds VBA. While VBA’s "no install" advantage fades with cloud-based Python, path dependency may slow adoption—but fewer new users will learn VBA.