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 原生集成到 Excel 公共预览版中，这将允许数据分析师、工程师、营销人员亦或是学习数据科学的 ...

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.