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

取代 VBA？ Python 之父加入微软三年后，Python 重磅集成到 Excel CSDN · 2023年08月23日 04:30 微软拥抱 Python ...

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.