File Exists

[glen.e.mettler]

Using 2003 - I need to know if a file exists in a selected folder.
When I looked up the FileExists function in the online help I found the
following:
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.

That doesn't tell me anything I can understand. There isn't any
example.

Let's say the file I need to know about is "ABC.txt" and the folder I
will query is C:\MyFolder. What is the code I need to write that will
tell me if the file exists or not?

Glen

 

[Ron de Bruin]

You can use Dir Glen

If Dir("C:\MyFolder\ABC.txt") <> "" Then

 

[zz]

"dir" function is also helpful

if dir("file.txt") then
do_something
else
do_something_else
endif