VBA--Does a File Exist

[Larry.LeBlanc@O]

How can I use VBA in Excel to determine if a file with a known name exists in a known directory?

[shg]

Please Login or Register  to view this content.

[Larry.LeBlanc@O]

I found that I can also use
Dir ("Full path name")

If this is the null string, the file does not exist. If the file does exist, Dir will equal the name of the file.

[shg]

Sure. The LEN function is faster, but the result is the same.