What is a macro. Learn the details

The modern secondary school program includes consideration of the question, what is a macro, into the framework of computer science lessons. For those who are not fortunate enough to experience the merits of the current education, and those who have even attended these lessons, it will not be superfluous to learn about this in more detail. Most modern users are superb without this knowledge and skills and do not even think how to create a macro. But those who are not too lazy to give a little time to study this question can greatly simplify their lives. After all, to perform routine boring work, software developers have created many useful applications that make life easier for a typical PC user.

The function "macro" is included in the composition of powerful editors and file managers, it remains only to find the appropriate item in the menu to take advantage of its capabilities. There are separate utilities that allow you to use it outside of these programs. When you run them, you do not even have to think about how to enable macros. Thanks to a simple intuitive interface, this will not cause you any difficulties.

Answering the question, what is a macro, you can rely on the classical definition. It says that this term should mean a set of instructions that are written and executed by a specific program. Initialize the execution of the macro can be a combination of certain keys, by clicking the appropriate icon or by using the toolbar menu.

At Microoft, it has always been important to use the useful properties of macros. In Word / Excel, macros perform a lot of useful functions inherent in the body of programs, it is also possible to create their own command sequences and then write them.

At its core, macros are analogous to programming, only to work with them, knowledge of the features of a particular language is not required. You just need to identify a clear sequence of the necessary commands, turn on the recording mode and execute them once. Later this sequence will be executed automatically. Supersyllabic operations on the shoulders of macros should not be entrusted, but in the execution of frequently repeated commands they are an indispensable assistant. If you answer the question, what is a macro, at a household level, then you can compare it with a culinary recipe. A modern washing machine or bread maker is an example of an action that in a computer language can be safely called a macro.

For initial acquaintance with the capabilities of macros, it is enough to open Microsoft Office. To format a macro with text, you need to select it. Then, following the route Service> Maxros> Start recording, go to the macro recording dialog box . Set the name of the macro or leave the default Macro1.

In various subsystems of Microsoft Office, you can assign a combination of keys to start execution of the recorded sequence of commands.

After performing the necessary operations, stop recording on the route Service> Macro> Stop recording.

To edit a macro, you need to use a certain amount of knowledge. Following the macro through the "Service", press the combination Alt + F8. Click the "Change" button. In the Visual Basic editor window, we not only can view the corresponding module, but also modify it. Among the main elements is the keyword "Sub", followed by the name of the macro. Comments start with an apostrophe "'". Between the words Sub and End Sub is the body of the macro. This is a normal text that can be adjusted and changed. Knowing how certain actions are interpreted, you can even add them to the body of the macro.

Having received the initial knowledge of what a macro is, you can develop your skills in writing and creating useful and reliable assistants in your daily affairs.