Purpose of the pages
Pages here provide tips in automating audit with the help of Excel's macros.
|
|
Using the Macros (Added 25.11.2008)
You are free to use the Excel macros here, unless otherwise said on certain page.
|
|
|
Using the macros is simple. You need Ms Excel, the source code, and the Userform(s) that the macro uses.
On this site the two latter are usually in a winzip file,
the files in which you must first extract to a drive or to a memory stick.
|
| - |
Open Ms Excel, select "Tools - "Macros" - "Visual Basic Editor" (or Alt + F11).
|
| - |
Select [in VBA]: "File" - "Import File", and select the module of the macro (*.bas).
If there is no file with extention 'bas' but with extention '.txt'
then select "Insert" - "Module".
Copy the source code of the macro from a text file, and paste it to Module.
|
| - |
Select [in VBA]: "File" - "Import File", and select the userform(s) of the macro (*.frm).
|
| - |
Now, you have an operational macro in Excel.
Just select [in Excel]: "Tools" - "Macros" - "Macro" [select the macro] - "Run".
|