William Hindman
wdhindman at dejpolsystems.com
Sun Mar 22 16:44:01 CDT 2009
Group
...the following function has been working fine in all versions of Access
from A97 through A2k2 but fails in A2k3
...I use it to delete any txt files in the directory before importing a new
one into it.
...regardless of the presence of .txt files it returns the 2nd msgbox and
does not delete the txt files in the directory
...I'm stumped ...anyone have any idea why its not working in A2k3? ...what
am I NOT seeing?
-------------------------------------------------------------------------------
Function KillTxt()
Dim fs As Variant
Dim i As Integer
Dim FileList As String
' Change to the appropriate folder
ChDir "C:\Program Files\EMSReports\Imports"
Set fs = Application.FileSearch
With fs
.Lookin = "C:\Program Files\EMSReports\Imports"
.FileName = "*.txt"
If .Execute > 0 Then
FileList = "*.txt"
Kill "C:\Program Files\EMSReports\Imports\" & FileList
MsgBox "There were " & .FoundFiles.Count & " *.txt file(s) found in
the C:\Program Files\EMSReports\Imports directory and deleted."
For i = 1 To .FoundFiles.Count
MsgBox .FoundFiles(i)
Next i
Else
MsgBox "There were no *.txt files found in the C:\Program
Files\EMSReports\Imports directory."
End If
End With
Set fs = Nothing
End Function
------------------------------------------------------------------------------
William