Checking if a file exists in a folder

[Tomexx]

Hi,
How can I check if file exists in my app's directory?
Thanks.

Use the Dir$ function.

If Dir$("MyFile.txt") <> "" Then
    Print "File exsist"
Else
    Print "File does not exsist"
End If

[JackV]

Though it might be overkill, you can use the FileExists method of the File System Object.

First declare a reference to the Microsoft Scripting Runtime Library.

   Dim fso As New FileSystemObject
   Dim bFileExists as Boolean

   bFileExists = fso.FileExists(App.Path & "\MyFile.txt")
   
   Set fso = Nothing