Macro - Check Gaps

Sub RunGaps()
'
' checks for gaps in numeric sequences 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 (e.g. check number)
' Report - where the report is to be written
' Note that the sequence of parameters does not matter
'
Dim oEZ As New cEZ

oEZ.Gaps _
Infile:="c:\test\xlac\data\dupinv.txt", _
Report:="c:\temp\test\dupinv.rpt", _
Column:="InvoiceNo"

LoadSheet _
ToSheet:="$Debug", _
Infile:="c:\temp\test\dupinv.rpt"
Set oEZ = Nothing

End Sub

Main Page

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

	Macro - Check Gaps
	Benford's Law Downloads Site Map