>Hi All,
>
>Is there any VB command/function that checks a file if exist in the directory or not and return False/True?
>
>BR

Ahmad,

The Dir() function can be used for this although it returns an empty string ("") if the file does not exist. If it absolutely has to return True or False you can create your own function that captures the return value of Dir() and returns True or False depending on the return value of Dir(). The syntax for its use is something like:

If Dir("c:\mypath\myfile.txt") = "" Then
  'code to indicate the file does not exist
Else
  'code to work with the file
Endif

Although not a VB command or function, you can use the FileSystemObject also and it does have the FileExists() function that returns True/False if the file exists or not. Add a reference to the MS scripting runtime and then do something like:

Dim FSO as Scripting.FileSystemObject
Set FSO = New Scripting.FileSystemObject
Debug.Print FSO.FileExists("C:\mypath\myfile.txt")

Hope this helps.