When it comes to portability, Python is a clear winner. VBA code can be version-dependent. Besides, the VBA code written for Excel on Windows might not work on Excel for Mac.

Microsoft is rolling out a new Python Environments extension in VS Code, now reaching 20% of stable channel users. The tool ...

Python and Excel can only really talk to each other through limited functions—xl () and =PY ()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.