-
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.
-
Re: FileExists
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
-
Re: FileExists
vbNullString instead of "" ;)