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.

Python developers using Visual Studio Code are getting an AI-assisted boost from the editor's IntelliCode extension, just released in a preview.