Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Exists
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Exists
You can use Dir Glen
If Dir("C:\MyFolder\ABC.txt") < "" Then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Exists
"dir" function is also helpful
if dir("file.txt") then do_something else do_something_else endif wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If a file exists then do this... | Excel Programming | |||
File Exists | Excel Programming | |||
IF File Exists | Excel Programming | |||
File already exists | Excel Programming | |||
the file already exists - do you want to replace the existing file? | Excel Programming |