FileExists

How can I (gracefully ) check and handle (if it does not exist) that a file exists before opening it, without using FSO's?




FileExists Method


Description

Returns True if a specified file exists; False if it does not.

Syntax

object.FileExists(filespec)

The FileExists method syntax has these parts:

Part Description
object Required. Always the name of a FileSystemObject.
filespec Required. The name of the file whose existence is to be determined. A complete path specification (either absolute or relative) must be provided if the file isn't expected to exist in the current folder.

Easier.
You can check for files or folders

Code:

---

Option Explicit

Private Sub Form_Load()
  If Dir("d:\temp\alexa.jpg") = "" Then Beep
End Sub

---

vbNullString instead of "" ;)