What is the difference between VBA and VB?

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.

In addition, if you prefer, you can also use Excel as a development platform to implement applications.

Benefits of application-based automation in an Excel environment.

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.

VB is a programming environment language that enables the development of practical applications. VBS is a script based on the VB language, which cannot be run independently and requires a host program.

VBS is based on Visual Basic scripting. The full name of VBS is: Microsoft Visual Basic Script Edition.

Microsoft Corp. Visual Basic Scripting Edition). Visual Basic (VB) is a general-purpose object-based programming language developed by Microsoft, which is a structured, modular, object-oriented, event-driven visual programming companion language that includes an event-driven mechanism to assist the development environment. is a language that can be used in Microsoft's own product development.

"Visual" refers to the method of developing a graphical user interface (GUI) - without having to write a lot of ** describing the appearance and position of interface elements, you can simply add pre-built objects to a point on the screen. "Basic" refers to the Basic (Beginners All-Purpose Symbolic Instruction Code) language, which is the most widely used term in the history of computing technology.

The differences between VBA and VB in Excel are: different properties, different running dependencies, and different independence.

First, the nature is different.

1. VBA: VBA is a subset of VB, which is to automate existing applications (Excel).

2. VB: VB is an application designed to create application (excel) standards.

Second, the operational dependencies are different.

1. VBA: A program developed by VBA must depend on its parent application.

2. VB: To run the application developed by VB, the user does not need to install VB, because the application developed by VB is an executable file.

3. Independence is different.

1. VBA: VBA has poor independence and must be parasitic on existing applications.

2. VB: VB is independent and has its own development environment.

The full name of VBA is Visual Basic for Applications, and VB is Visual Basic, which is a programming language that is simply packaged and executed, and the latest version is. .NET, the former is a macro language that contains various software from Office, and the differences between the two are as follows:

Compilation execution file: The extension of the execution file is exe, and VB can make exe files because it contains a compiler. VBA, on the other hand, is contained in the Office series of software and does not provide a compiler, so the VBA program can only be executed by relying on each software, and the executable file cannot be made.

Available resources: that is, resources that can be referenced within the program, including objects, functions, etc. VB's resources in this area are wider than those of VBA, because compared with the two, VB is a more professional programming language, and the purpose of VBA is to strengthen the Office application system, so in terms of available resources, VBA is not as good as VB.

Basic syntax: VBA and VB syntax are exactly the same, so as long as you have a little basic basic, you can use VBA.

Description: Therefore, VBA can be said to be "the basic syntax built into each software", and it is unified, that is, as long as you learn to use basic, and then understand the objects owned by each software, such as access is a database (database), excel has a workbook (workbook), worksheet (sheet), cell (range), word has a file (document), etc. The purpose of these objects is to automate the processing of files within the program.

I also rely on others, please refer to the relevant materials for specific differences.

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.