• Home
 · 
• Files/File Controls/Input/Output
 · 
• A Beginner method to check whether a file exists

A Beginner method to check whether a file exists

A Beginner method to check whether the file exists or not. It is simple, easy to understand and should able to run on different Window OS.

Rate A Beginner method to check whether a file exists

• 1
• 2
• 3
• 4
• 5

(8(8 Vote))

Public Function CheckFile(InFileName As String) As Boolean 

 On Error GoTo ErrHandler 

 CheckFile = False 

 'Check whether the file or folder exist 

 If Dir(InFileName) <> "" Then 

 'Check is it a directory(folder) 

 If (GetAttr(InFileName) And vbDirectory) = 0 Then 

  CheckFile = True 

 Else 

  MsgBox "File doesn't exist!", vbCritical 

  Exit Function 

 End If 

 Else 

 MsgBox "File doesn't exist!", vbCritical 

 Exit Function 

 End If 

ErrHandler: 

 
End Function