The easiest way to automate the task – simply record a macro, and vba will do the job for you. This way of creating a macro, we use quite often. Those to me, however, to realize all the possibilities of language vba, have to use some programming tools, ie have to write your own macros. Benefits of creating a macro, based on already recorded: 1. If writing a great macro with a huge amount transactions you make a mistake, you can edit the macro and fix the problem.
You do not want to overwrite the entire macro from the beginning. 2. You'll have full control over each macro. In other words, you make sure that your macros perform exactly those actions that put them to perform. 3. You can use the hidden features of vba to administer the programs of Office, which are available at auto macro recorder. In addition, you can manually write a more professional and efficient routines. To display on-screen editor of Visual Basic, in any Office application, choose Tools => Macro => Editor Visual Basic.
Visual Basic Editor is a separate program that was designed with the sole purpose – to help you in creating and editing macros, vba. (In professional circles, programming the Visual Basic editor is called integrated development environment). When you first open the editor you will not see anything special. The left side of the editor contains two windows, which are called the Project (the Project) and Properties (the Properties). In the Project window displays the contents of the current project vba.