Which one should I learn, python or vba?

Visual Basic for Applications (VBA) is a macro language of Visual Basic, a programming language developed by Microsoft to perform common automation (OLE) tasks in its desktop applications. It can mainly be used to extend the functionality of Windows applications, especially Microsoft Office software. It can also be said to be a kind of basic script for application visualization.

This language was developed by Microsoft in 1993. Applications share a common automation language----Visual Basic for Application (VBA) , in fact VBA is a parasitic version of the VB application. The Excel 5.0 version released by Microsoft in 1994 already had the macro function of VBA. (Recommended learning: Python video tutorial)

Python is a computer programming language. It is an object-oriented dynamic type language that was originally designed for writing automated scripts (shells). With the continuous updates of the version and the addition of new language features, it is increasingly used for the development of independent and large-scale projects.

Python is an interpreted scripting language that can be used in the following fields:

Web and Internet Development

Scientific Computing and Statistics

Artificial Intelligence

education

Desktop interface development

Software development

Backend development

According to foreign media reports, Microsoft Python is being considered to be added as an official Excel scripting language. If approved, Excel users will be able to use Python scripts to interact with Excel documents, data, and some Excel core functions just like they currently use VBA scripts.

So far, more than 3883 people agree to integrate Python into Excel and become a VBA replacement. Even cell function functions (=SUM(A1:A2)) can also be used with the Python function sum( a1, a2) instead of

Currently, Microsoft officials have responded positively by launching a poll to collect more user feedback and conduct an online survey on how users want to use Python in Excel.

Some users believe that if Microsoft takes this route, then in order to facilitate daily use, Microsoft will also need to support Python in all other Office applications.

For more Python related technical articles, please visit the Python Tutorial column to learn!

The above is the detailed content of Which one should I learn, python or vba?. For more information, please follow other related articles on the PHP Chinese website!