Tuesday, February 07, 2012

Automate tasks with Macros

What are macros and where can it be used?

A macro is a set of one or more actions that each perform a particular operation, such as opening a form or printing a report. Macros can help you to automate common tasks. For example, you can run a macro that prints a report when a user clicks a command button.

In general, a macro is nothing but a series of commands an application program executes. Macros let you program your software without requiring you to learn or even understand the basics of writing a program. For example, both word and excel support macros you can use to automate a series of commands. When you record and then execute a macro, it typically mimics the steps a user would take when manually using a program.

Macro software's to automate tasks:

1. AutoIT


AutoIt is a very popular macro freeware but it is not easy to use. It is powerful and it uses BASIC-like scripting language designed for automating the windows GUI and general scripting. It can perform a lot of tasks and then able to convert the script into an executable.
You can download it from here - Download AutoIt
2. AutoHotkey

AutoHotkey is also another popular macro freeware. It can automate almost anything by sending keystrokes and mouse clicks. Although AutoHotkey also requires scripting, but there’s AutoScriptWriter by Larry Keys which you can use to record mouse and keystrokes. Once you stop the recording, it will give you the commands.
3. Do It Again
This is simple to use, just click record “Create a New Task” to start capturing your task. Press SCROLL LOCK button to to stop the capture. Although Do It Again doesn’t support keyboard shortcut to run an automated task, you can create a shortcut to the corresponding .dia task file and then modify the properties of that shortcut to set a keyboard shortcut. Do make sure that you’ve associated .dia files with Do It Again. Windows already has this function for shortcuts. If you want to increase the pause time, you can open the .dia file with notepad and increase value for Pause.
4. Macro Express (Shareware)
Macro Express has a scripting editor that creates commands and also automatic recording. There is a feature that not many macro software has which is you can set the macro to repeat how many times. I always use this command for data input because I don’t want the macro to keep running.

No comments:

Post a Comment