Hello, I would like to check if a file exists before I process it. Is there a command or routine I could run which would determine the existence of a file if I provide it with a path\filename, e.g. "C:\Photos\01234.jpg"? Thank you.
How can I determine if a file exists?
- Thread starter PRD
- Start date
G37Sam
Registered User.
- Local time
- Tomorrow, 00:18
- Joined
- Apr 23, 2008
- Messages
- 454
- Local time
- Today, 20:18
- Joined
- Sep 12, 2006
- Messages
- 16,094
fileexists = dir("yourpath")<>""
G37Sam -
Just a follow-up for what its worth, if you change the property of 'sPath' from 'String' to 'Variant' the macro will not blow up with an 'Invalid use of the Null' error if an invalid path is used. Otherwise this is really a great and useful subroutine - a real life-saver. Thanks again.
Just a follow-up for what its worth, if you change the property of 'sPath' from 'String' to 'Variant' the macro will not blow up with an 'Invalid use of the Null' error if an invalid path is used. Otherwise this is really a great and useful subroutine - a real life-saver. Thanks again.
Similar threads
