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.

In the December update to Python in Visual Studio Code, developers can experiment with a new preview feature that lets them run and debug Python code in the browser.

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.

Exploring the special relationship among VS Code, Python and data science, which has resulted in nearly 158 million installs of related Microsoft dev tools and numerous No. 1 rankings in various ...

For developers keen on using programming language Python, there's a new tutorial that shows how to build a Python application in a Docker container using VS Code and Microsoft's VS Code Docker ...