Macros

1
Macros

• Intermediate 2
• Unit 2 Software Development

2
Recap questions

• Name the two main types of translator programs
• Which one translates a whole program into machine
  code before it is executed?
• Which one translates a program line by line as it
  is being executed?
• Why do machine code programs run more quickly on
  a computer than high level language programs
• Convert 167 to binary

3
What is a Macro?

• A way to automate a task that you perform
  repeatedly or on a regular basis.
• Series of commands actions that can be stored
  and run whenever you need to perform the task
• Instructions can be simple, such as entering text
  and formatting it,
• They can also be complex, like automating tasks
  that would take several minutes to do manually

4
Creating a Macro

• Macros can be created in 2 ways
• Recording the actions to be carried out from with
  in the package
• Writing a small program using a scripting
  language eg VBA or JAVA

5
Running A Macro

• A macro can be initiated by
• pressing selected key combination
• This is called using Hot Keys
• Clicking an icon on the toolbar that has been
  created for the macro
• Running the macro from the Tools menu of the
  application

6
Exemplar tasks

• Inserting your name and address on documents
• Formatting text with specified font and size
• Accessing websites from a list of favourites
• Inserting special symbols or graphics into
  documents

7
Class Exercises

• Go to page 28 and work through example 1. Create
  the spreadsheet and then record a new macro
• Go to page 33 and work through the unit questions
  on the PC