Procurement Audit Step 1
Procurement Audit Step 1 Benford's Law Fraud detectionDownloads First digits lawSite Map
Home Page | Population | Sampling | Fraud | Other | Tutorial | Macros
Procurement Audit Step 1
Sub POStep1()
'
' extract the purchase order data from the Access database
' load the data onto sheet $Data
'
Dim oEZ As New cEZ

Application.ScreenUpdating = False
Application.Cursor = xlWait
oEZ.ODBC _
Conn:="c:\test\xlac\data\poext.mdb", _
SQL:="Select * from poext", _
Extract:=BASEDIR & "poext.txt"

LoadSheet _
ToSheet:="$Data", _
Infile:=BASEDIR & "poext.txt"

Set oEZ = Nothing
Application.Cursor = xlDefault
Application.StatusBar = "PO - Step1 "
End Sub

 

 

 

 

Main Page

Complete Auditor resources
Links | Privacy Policy | FAQ | Downloads | Trademarks
Web Page last updated on 04-20-2008
© EZ-R Stats, LLC 2005-2007