© Matti Mattila, CPFA, CISA, CIA

Miscellaneous IDEA Macros

(12.01.2004)
Macro is short program that executes statements and commands specified in its source code. You make macros in IDEA with IDEAScript, an object oriented programming language - consistent with Microsoft's Visual Basic and LotusScript. As written in IDEA Help
"Scripts, which are often called macros, can be created either by recording a series of IDEA steps, by copying from other scripts, by copying from the History, or by typing into a Macro Window. Often a combination of all three methods is used with the main steps being recorded, additional items copied in and then final editing in the Macro Window. Scripts can be attached to the Tools menu or to a Toolbar Macro Button or run simply from the Tools Macro menu. It is not necessary to open the Macro Window to run a script although scripts can be run from within this window."
Using macros you can automate audit routines, e.g. have sophisticated analyses and exception tests made just clicking a macro button in toolbar. To put it there select: "View - Customize Toolbar... Macro Commands.."; 1) select icon; 2) search the macro in "Command"; 3) drag and drop the icon into Toolbar.
In this section you will be introduced some simple scripts that you can use as such or after modification in macros of your own.
Macros

CROMM Macro
17.12.2001
File/Field Selection (Code)
26.01.2004; 16.02.2004
Field Examining Macro
08.03.2004
Text Search Macros
05.04.2004 - 06.05.2008
File Renaming Macros
26.04.2004 - 06.07.2010
[Raw] Data Manipulation Macros
16.05.2006 - 14.11.2006

Return to Main Site
Site Map