Discussion Locked

WHAT IS A MACRO?

0 helpful
15 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What is a macro and is it interchangeable within MS applications?

15 replies

by guy

Macros are really no more than recordings of all the instruction that you could do manually. E.g. File New. Type in Address and Phone number, put in today's date, GOTO Dear Sir. Those are the instructions, they are recorded, then you replay them with one command like ALT SHIFT L.
That would be a simple MACRO. The skill is to use special instructions to develop program loops to repeat e.g. make one row, make another row, keep on until you have made 12 rows.
So langauages have been developede.g. Visual Basic to make macros more powerful.
To get started go to word, and record a macro, and replay it. At the other extreme, use built in macros.

by dmiles

Macro is a series of word commands and instructions that you group togeather as a single command to accomplish a task automatically.Acustom command
Uses for macro
1.To speed up editing
2.To combine multiple commands
3.To make option in dialogue box more accessible
Macro has to be created with each application

by coffee lady

A macro is a sequence of word actions that u can record or a write in a form of Visual Basic for application code. U can then run the macro to play back the action with one key. This is very good to use in word. The pictures (shortcuts)that you use on the toolbars in word are all macros, EX: printing, saving and closing etc.

by waifoon

A macro is able to automate task you perform frequently. If the task you would like to automate is simple, like say to always copy a spreadsheet from one workbook in Excel to another workbook, you can record your macro by going to Tools, Macro, Record New Macro. Once this macro is recorded, you just activate this macro every time you want to do the above-mentioned task.
Alternatively, if you have a more complex task to do, then you can use Visual Basic to create the macro.

This discussion is closed to new replies.