VBA overview Creating your own applications in office products

VBA overview

VBA (Visual Basic for application) is an application of the VB language in office products, based on Visual Basic for Windows Development, Visual Basic for Windows is a programming language developed by Microsoft in 1992 to develop Windows applications that is popular with users because of its simplicity and ease of use. The syntax structure of VBA is essentially similar to Visual basic for Windows, but there is a fundamental difference between them, and Visual Basic for Windows is a programming language that can create stand-alone applications. VBA is a scripting language that resembles the syntax structure of visual Basic for Windows, and is typically embedded in Microsoft Office products for execution.

Prior to Office 2000, VBA was used differently in office system software such as Word, Excel, access, and so on (at that time, there were few products in the Office family), but it was unified by Office 2000. Excel is the first Office product that contains VBA, and is one of the most widely used software in VBA today. Since Office 2000, there is already a unified standard macro language VBA in Excel, Word, PowerPoint, and Access, where VBA of Excel and Access is the most mature (starting with Office 2000, The number of products in the Office family began to rise.

Starting with Office 2003, Microsoft has gradually added many products to the Office family, such as OneNote, Publisher, Inforpath, Visio, and so on, but in addition to expanding objects in VBA, There has been no significant change in the application of VBA, and some products have not been extended to VBA because of problems with use.

Today, Office 2007 has arrived, and there have been some changes in support for VBA, as Microsoft. NET product series of continuous expansion and in-depth,. NET is also embedded in a variety of Microsoft products, and VSTO is an upgrade program specifically for VBA applications in office products, which I'll introduce to readers in the next few articles. However, Excel is still the most widely used VBA product in the Office family, so I'll take Excel as an example to introduce the use of VBA and do some examples based on Office 2007 software.

Let's start by looking at what we can do with VBA in Excel.

Excel is a powerful software for working with tabular data that can be used to do many different things, such as recording the customer's name and student's test scores, carrying out budget estimates, analyzing experimental data, making invoices and forms, passing a given data graph, and so on, Excel's various functions are applied to all walks of life, but one thing is the same, that is, when the amount of data to be processed is very large, all users expect Excel to be very smart to deal with some things themselves, "Let Excel move" is what VBA can do!

For example, we can write a VBA program to format the report, and print it out, after development and testing, we can end up with just one command to do all the work, without the do-it-yourself to knock commands, click the mouse to find the menu ... Excel can do all the work in a flash, why not?