VBA Macros demystified

Macros demystified: what they are and what they are used
What is a macro?
A macro is a set of commands that can be applied with a single click. They can automate almost any task that can be performed in the program you are using and even let you perform tasks did not think possible.
Are macros a type of programming?
Macros are programming, but need not be a programmer or programming skills to use them. Most macros that can be created in the Office programs are written in a language called Microsoft Visual Basic for Applications, known as VBA. VBA macros are discussed in this article.
What is a macro?
A macro is a set of commands that can be applied with a single click. They can automate almost any task that can be performed in the program you are using and even let you perform tasks did not think possible.
Are macros a type of programming?
Macros are programming, but need not be a programmer or programming skills to use them. Most macros that can be created in the Office programs are written in a language called Microsoft Visual Basic for Applications, known as VBA.
Macros save time and expand the possibilities of the programs you use every day. You can use macros to automate tasks repetitive document production, to streamline cumbersome tasks or to create solutions to automate the creation of documents that you and your colleagues use regularly. Users who are familiar with VBA macros can be used to create custom plug-ins or templates including dialog boxes, or even record information for use in different occasions.

http://office.microsoft.com