the LIFELINE of Technology Industry

Macros are recorded series of actions that let you perform tasks quickly. These are based on Microsoft® Visual Basic® For Applications (VBA), which is included in the installation of any standalone programs like MS Office, Corel Draw etc.

You can take advantage of the VBA macros available in the program, and you can record your own macros to automate tasks that you perform frequently. Recording macros is easy — you don’t need to know VBA to get started.

Simple VBA macros let you complete basic operations, such as saving files to a different file format or drawing shapes. However, VBA can also be used to create richer macros and applications to help you with complex tasks. For example, using the Calendar Wizard included in the program, you can create multi-page and single-page custom calendars in different languages.

If you want to access your favorite macros quickly, you can add buttons to your workspace.

To Play a Macro in MS Office..

Let i show you How to to Uppercase any selected matter to upper case using a macro

a very simple macro already included in MS Word just to show how it works

1. Select any matter from your document and Click Tools> Macro> Macros or Alt+F8

2. Locate all caps macro from the drop out menu “Macros in” and selecting in word commands.

3. Select it and click run and u will find it the matter u selected immediately changes to all caps.

This is very simple and even u can do this by just by Ctrl+SHIFt+U but it was just to show you how a macro works.

And Here is how it was created

1. Click Tools > Macro > Record New macro

2. Save any name as you wish and press ok. You will notice a small tool bar with two button on it. One for Stop and another for resume.

3. Let  i have some matter written on page say ” make this text to uppercase”

and I select it and changes it to uppercase. and after that i stop the macro.

This is three simple step i used to record a macro to change the case of any selected macro.

Now look how it will be run

Go to same process as i have described earlier to run a macro instead locate macro in all active documents and templates as shown below

There you will find your recorded macro and with any text selected  when u run it the selected text will change to upper case instantly.  This is how u can create more complex macros for your daily use.

For More information about macros and their features please visit here

Trackback URI | Comments RSS