Checking for File Presence

[jkfeagle]

This probably has a simple answer and I've looked through the forum to no avail but...... does anyone have a snippet of code that checks for the presence of a file? Thanks in advance.

 

[boblarson]

Look into the DIR function:

If DIR("YourFilePathAndNameHere") <> "" Then
' file exists
Else
' file doesn't exist
End If

 

[jkfeagle]

Thanks Bob. I knew there'd be a simple answer. My brain is fried...it's been a long week!