Macro - Cross Tabs

Sub RunXT()

' run the cross tabs routine
'
' Infile - name of the file to be checked
' Report - name of the file to contain the report
' Column - name of the first column for the cross tab
' Column2 - name of the second column
' AmountColumn - name of the column with the amount
' to be summarized
' Note that the sequence of parameters does not matter
Dim oEZ As New cEZ

oEZ.XT _
Infile:=BASEDIR & "xtab.txt", _
Report:=BASEDIR & "clmdensp.xt", _
Column:="Gender", _
Column2:="Type", _
AmountColumn:="amount"

LoadSheet _
ToSheet:="$Debug", _
Infile:=BASEDIR & "clmdensp.xt"

Set oEZ = Nothing

End Sub

Main Page

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

	Macro - Cross Tabs
	Benford's Law Downloads Site Map