Using VBA in Access to see if an external file exists? 1

[VoodooRage]

Is there anyway using VBA to check to see if an external file exists in a location. If I am not mistaken there was and "EXIST" function in VB5 you could use to determine if a file existed at a given location.

By the way, this site/forum is really FANTASTIC and very, very, HELPFUL. Thanks for everything everyone.

Lewis Akers

 

[bustell]

Use the Dir function:

If dir(&quot;C:\YourFileHere.txt&quot <> &quot;&quot; then the file exists.

If it returns &quot;&quot; then the file does exist.

You can also use the function to scroll through all files that match a certain pattern.
Pat B

 

[mincefish]

I have a need to see if a file exists, and if so, kill it - you could probably adapt that code to do what you want...

With Application.FileSearch
    .NewSearch
    .LookIn = "C:\"
    .SearchSubFolders = False
    .FileName = "MyFile.txt"
    .MatchTextExactly = True
End With


With Application.FileSearch
    If .Execute() > 0 Then
        'The file must exist - do what you gotta do!
    End If
    
End With

 

[mincefish]

bustell's way is loads better

 

[VoodooRage]

Thanks a bunch everyone!

Problem solved again by you guys!