Check file existance : File « File Path « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. File Path
  3. File

Check file existance

 
Sub ReadPersistedRecordset()
    Dim strFileName As String

    strFileName = "c:\test.txt"

    If Len(Dir(strFileName)) = 0 Then
        msgBox "File Not Found"
        Exit Sub
    End If


End Sub








Related examples in the same category

1.Does the specified file exist?
2.Gets the file name from the path.
3.List all files under application path
4.Select a folder
5.Select a location containing the files you want to list
6.processes multiple stored files
7.Common File Operations Simplified
8.Use array to store a list of files