Macro

Macro programming is similar to computer languages, except the instructions are running inside an application.

For example an Office program such as Excel has an extensive macro language (called VBA) that allows an expert to extend the normal use of the application.

For instance, there may be a repetitive but complex task needing to be done regularly such as updating a spreadsheet with incoming data. A VBA programmer can largely automate this task by writing one or more macros.

To speed up development, a 'macro record' facility is often available where you can go step by step through the required actions using the standard application icons and every step becomes part of the final macro.

2020-10