NUPE2006
asked on
error: Path not found
Greetings,
I get a path not found error on lines 46 and 62 when I run the code below. I've had my declarations checked and still can't locate the error. The program compiles so I believe there is a problem with my logic.
-Thanks
I get a path not found error on lines 46 and 62 when I run the code below. I've had my declarations checked and still can't locate the error. The program compiles so I believe there is a problem with my logic.
-Thanks
Private Sub cmdYesD_Click()
'Dim fso As New FileSystemObject
Dim File1 As File
Dim Folder1 As Folder
Dim FileCollection As Folder
Dim strRegion2 As String
Dim intDays2 As Integer
Dim intDelete As Integer
Dim intDeleteFolder As Integer
Dim TotalFiles As Integer
Dim ProcessedFiles As Integer
strRegion2 = Me.txtRegionConf.Text
intDays2 = Me.txtInputDays.Text
ProcessedFiles = 0
intDelete = 0
intDeleteFolder = 0
'Deletes Files
If fso.FolderExists("Z:\" & strRegion2 & "\Customer\Output") Then
Set FileCollection = fso.GetFolder("Z:\" & strRegion2 & "\Customer\Output")
'Set progress bar maximum to files + folders
TotalFiles = FileCollection.Files.Count + FileCollection.SubFolders.Count
Me.ProgressBar1.Max = TotalFiles
'search for and delete files
Call Cleanfiles(FileCollection)
Me.Refresh
Call Cleanfolders(FileCollection)
Me.Hide
frmFFMMain.Show
MsgBox "Complete. Deleted: " & vbCrLf & intDelete & " files and " & vbCrLf & intDeleteFolders & " Folders"
Else
Call RegionError
End If
Me.Hide
frmFFMMain.Show
End Sub
________________________________________________________________________
Private Sub Cleanfiles(ByRef FileCollection As Object)
For Each File1 In FileCollection.Files
'Move Progressbar
ProcessedFiles = ProcessedFiles + 1
Me.ProgressBar1.Value = ProcessedFiles
Do Until TotalFiles
If DateDiff("d", FileDateTime(File1), Now) >= intDays2 Then
fso.DeleteFile (File1)
intDelete = intDelete + 1
End If
Loop
Next
End Sub
________________________________________________________________________
Public Sub Cleanfolders(ByRef FileCollection As Object)
For Each Folder1 In FileCollection.SubFolders
'Move Progressbar
ProcessedFiles = ProcessedFiles + 1
Me.ProgressBar1.Value = ProcessedFiles
Do Until TotalFiles
If DateDiff("d", Folder1.DateCreated, Now) >= intDays2 Then
fso.DeleteFolder (Folder1)
intDeleteFolder = intDeleteFolder + 1
End If
Loop
Next
End Sub
________________________________________________________________________
Public Sub RegionError()
'If fso.FolderExists("Z:\" & strRegion2 & "\Customer\Output") = False Then
MsgBox "Error: Region not Found"
Me.Hide
frmFFMMain.Show
'End If
End Sub
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER