What is VBA language What is VBA?

Until the early 90s, automating applications was a challenging area. For each application that needs to be automated, people have to learn a different automation language. For example:

Excel can be automated with Excel's macro language, Word Basic can be used to automate Word, and so on. Microsoft decided to make the applications it developed share a common automation language--- Visual Basic for Application (VBA), which can be considered a subset of the very popular application development language Vasual Basic. Actually, VBA is"Parasitic in"Version of the VB application.

The differences between VBA and VB include the following aspects:

1.VB is designed to create standard applications, while VBA is designed to automate existing applications (Excel, etc.).

2.VB has its own development environment, while VBA must be parasitic on existing applications.

3.To run an application developed by VB, the user does not have to install VB, because the application developed by VB is an executable file (*exe), and programs developed by VBA must depend on it"Father"Applications, such as Excel

Despite these differences, VBA and VB are structurally similar. In fact, if you already know VB, you'll find that learning VBA is very fast. Correspondingly, learning VBA will lay a solid foundation for learning VB.

And, once you learn how to create solutions in VBA in Excel, you already have most of the knowledge to create solutions in VBA in Word Access Outlook FoxPro Prowerpoint.

One of the key features of a VBA is that what you learn can be transferred to each other in some of Microsoft's products.

VBA can be called Excel"Remote control".

What exactly is a VBA? More precisely, it is an automation language that automates commonly used procedures, which can create custom solutions.

Maybe you're wondering what a VBA can do? Taking Excel as an example, the functions that can be achieved with VBA include:

1.Automate repetitive tasks.

2.Customize Excel toolbar, menu, and interface.

3.Simplify the use of templates.

4.Customize Excel to make it a development platform.

5.Create a report.

6.Perform complex manipulation and analysis of data.

VBA stands for VB for Application, it is an automation language, parasitic on other applications, to put it simply, some applications develop VB environments in order to extend their functions, such as Office has VB environments. When used in detail, its syntax is no different from that of VB.

VBA (Visual Basic for Applications) is a macro language of Visual Basic, which is a programming language that performs general-purpose automation (OLE) tasks in its desktop applications. It can be used to extend the functionality of Windows applications, especially Microsoft Office software. It can also be said to be a basic script for application visualization.

VBA provides an object-oriented approach to programming and provides a fairly complete programming language. It is written in subroutines and functions, in the form of modules in access.

First, the subject is different.

1. VB: It is a general object-based programming language developed by Microsoft.

2. VBA: It is a macro language of Visual Basic, which is a programming language that executes general automation (OLE) tasks in its desktop applications.

Second, the language characteristics are different.

1. VB: a structured, modular, object-oriented, event-driven visual programming language that includes an event-driven mechanism to assist the development environment.

2. VBA: It can be used to expand the application functions of Windows, especially Microsoft Office software. It can also be said to be a basic script for application visualization.

Third, the role is different.

1. VB: With a graphical user interface (GUI) and a rapid application development (RAD) system, you can easily use DAO, RDO, ADO to connect to the database, or easily create Active X controls for efficient generation of type-safe and object-oriented applications.

2. VBA: You can use the macro recorder to record the various actions of the user and convert them into VBA programs**. This allows users to easily convert their daily work into a VBA program** and automate their work.

Microsoft decided to make the applications it developed share a common automation language--- Visual Basic for Application (VBA), which can be considered a subset of the very popular application development language Visual Basic. In fact, VBA is the version that parasitizes the VB application.

VBA is the abbreviation of Visual Basic for Applications, which is a functional programming for applications, and unlike other programming languages, the programming environment in which he lives does not have a compilation process, but only executes a functional process.

In terms of linguistic principle, it evolved from the VB language, and the grammar is mostly related to VB.

VBA calls the class module and the executable fragment a macro, which is different from the macro in C++.

VBA is widely used in Microsoft Office applications, open Office applications, such as Word Excel, etc., press and hold ALT+F11 to enter the VBA** module, access directly select the module, enter the programming interface or design form, report selection toolbar on the **button to enter **mode.

Examples of functional programming for VBA:

1.The third digit of the string starts with 5 digits, and VBA is represented as follows:

mid(string,3,5)

2.Execute internal SQL statements and store SQL statements in runsql macros.

runsql name".

3.The form is full-screen.