Answer 2_11_7
An office worker has made a macro to import data from one spreadsheet file to another, and then to perform some calculations. However the macro does not work when used.
(a) What is a macro?
(b) What should have been done to reduce the chance of failure?
(a) A macro is a small program that performs a function determined by the user. You record the key strokes as you do the function.
(b) He should have tested the macro to ensure that it works before using it. He needs to check the visual basic code to see if there is an error in the code.