Procurement Audit Step 10

Sub POStep10()
'
' checks for Benford's Law using the following parameters
'
' Infile - name of the file to be checked
' Column - name of the column value to be checked
' this will be a numeric column
' Report - where the report is to be written
' Bentype - type of benford report - F1, F2, F3, L1, L2, or D2
' Note that the sequence of parameters does not matter
'

Dim oEZ As New cEZ

oEZ.Benford _
Infile:=BASEDIR & "poext.txt", _
Report:=BASEDIR & "poext.ben", _
Column:="invamount", _
BenType:="F1"

LoadSheet _
ToSheet:="$Benford", _
Infile:=BASEDIR & "poext.ben"

Set oEZ = Nothing

End Sub

Main Page

Complete Auditor resources
Links \| Privacy Policy \| FAQ \| Downloads \| Trademarks