© Matti Mattila, CPFA, CISA, CIA

CAATsScripts

Updated 14.10.2008; 17.10.2008; 03.01.2008; 03.02.2009; 08.06.2010; 14.12.2010; 15.02.2011; 22.02.2011; 15.03.2011; 12.04.2011; 26.04.2011; 24.05.2011; 25.06.2011; 08.08.2011; 16.08.2011; 24.08.2011; 13.09.2011; 22.11.2011; 05.12.2011; 03.01.2012
Macros for sale
Invoice. You can download a price list and an invoice here. Fill in the invoice. Together with a payment document it should be valid for book-keeping. You may need to pay value added tax according to the rates of your own country.
Picture 1: Message when starting a run of a macro
How many licences do I need? You can have the macro simultaneously only on one computer, just like computer softwares that you have purchased. As a rule of thumb you should have one macro per an active user.
Payment. The invoice has information needed to make a payment. You can pay it by wire, but it might be easier to make the payment via PayPal.
Can I pay in other currency than US Dollars? You can make the payment in euros, too. When using PayPal there is no problem with currency rates. If case currency rates are not determined in any other way 8on this site] exchange reference rates of European Central Bank will be applied.
Delivery. After payment, please, send a delivery request for the macro(s) to email
"f-fs@welho.com", and you will get in return information for downloading a fully operational Macro.

An Example of a Delivery Request:
To: f-fs@welho.com
Subject:Delivery Request
Message: Hello! I have remitted USD 90 for "JoiTab2" macro on Apr 12, 2011 from my account [Email address in PayPal]. Please, deliver the macro and its source code to me, email: [email address].
Regards
[Your name]

Download. After receiving the message a verification of the payment takes place. You will get information needed to download the a Winzip file where one or more macros are. Downloading the file is easy. You will have 14 days for making the download. After downloading the worksheet containing the macro make a backup copy of the worksheet.
1. Excel Macros(Digitally
Available Excel Macro licences:
Macro's name and Functionality [1] Demo; Size [2] Introduction
TextImport3 - Imports an ASCII Fixed length Files to Excel
Demo macro reads max 100 lines.
xl07c3.zip
150.528
xl07c3.html
StringPivotTable - Makes a Pivot Table from Strings
(Demo table max 3 x 3)
xl07d2D.zip
106.496
xl07d.html
TexEdiMac #1 - For examination and editing text files
Demo macro processes max 20 lines.
xl07eD.zip
173.568
xl07e.html
TexImp4 - Imports Lines of a any Text File
Demo macro imports 50 lines or less.
xl07c4D.zip
106.496
xl07c4.html
JoiTab - Joins Two Excel Tables
Demo macro joins 10 lines or less.
JoiTab1D;2D.zip
128.000; 135.680
xl07f1.html;
xl07f2.html
ExcAud - All newest versions of macros above in one (Limitations above valid)
ExcAud1D.zip
558.592
xl07x.html
Excel File Edit Macros - copy/append Excel tables, remove spaces..
Demo macro valid till 31.03.2012.
ExcEdi1aD.zip
202.240
xl07i.html
FilNam; ReNam; FilLis - List file names; renames files; lists file names also in subfolders
Demo macro valid till 31.03.2012.
FilNam3D.zip
182.272
xl07m1.html;
xl07m2.html; xl07m33.html
Prices of licences of the macros are shown in a document here.
2. IDEA Macros
Not on sale anymore.

[1] In 'ExcAud' 'TextImport3' is 'ImpFix' and 'TexImp4' is 'ImpAny'.
Picture 1
[2] Size of Excel workbook "JoiTab1D.xls", which contains macro "JoiTab1", in a Winzip File. See the picture 1: "JoiTab1d.zip": "JoiTab1D.xls".
Here is a web site where to download Winzip to extract Winzip files.
Tips
Good to remember in Use of IDEA: CAATs basics
Miscellaneous Tips: Inquiries; Comparisons; Time recording system; File examination; Conversion tables; Risk based sampling; Print files; Entry analysis..
Complentary Continuos Audit System: Tips in building it
Macros:
Each macro has only the functionality that is needed to make the runs, and where needed, the functionality to check macro's time of validity. The macros are harmless for the user, for the computer, and for the software on the computer.
CROMM: creates Pivot Tables
Miscellaneous [IDEA] Macros: File/Field selection; Field examination; Text search; File renaming; [Raw] data manipulation
Excel Macros .......... for Auditors: Edit Text Files ('TexEdi') [for]; Import Text Files ('ImpFix'; 'ImpAny'); [and to] Join tables ('JoiTab'); Detect Gaps and Duplicates ('GapDup'); Make Pivot Tables even from Strings ('StrPiv') .......... and for all: Copy/append Tables; Make a List of Files and Folders; Rename Files; Add Header & Footer in an Excel Sheet
Legal Notice: Read this, too, please.
Return to Main Site
Site Map