1. AutoIT v3
If you are looking to script macros using a powerful, yet easy to follow and understand scripting language, AutoIT is an excellent option. You can write out lines of code that can be run with the AutoIT interpreter or you can optionally compile your scripts as small stand-alone EXE files that you can carry around with you, thus eliminating the need to provide the interpreter. AutoIT v3 is freeware.
Credit: Images by Matthew Nawrocki for TechRepublic