Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using VB to query a group of text files for buzzwords contained within
them. But to simplify my situation I will say I am only interested in determining the modified date of each file. I have attempted to use an error handler within a for loop. The plan: A random list of file names are in Column A. Column B will list the modified date for each. If the file is not found, "Error reading file" is listed in column B instead. The reality: I receive a run-time error 53 if there are two or more invalid filenames simultaneously. I have read through the VB help for 'On Error Statement' and understand that the error handler cannot handle an error until the previous error is 'handled'. So my question is, "Is there a way to clear the handler and allow the next loop to continue?" Or is there an alternate way to reach the same thing like ignoring the error? A portion of my program is below. Thanks in advance. For Blank = 1 To 10 On Error GoTo Line6 fName = Cells(Blank, "A") Cells(Blank, "B").Value = FileDateTime(fName) GoTo Line8 Line6: Cells(Blank, "B").Value = "ERROR ACCESSING LOGFILE" Resume Next Line8: Next Blank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Do while loop error.... | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Problem with 'For' loop execution [VBA,Excel XP] | Excel Programming | |||
loop error | Excel Programming | |||
loop error | Excel Programming |