how to check if a file exists in excel?
All you need to do is pass it the full filename as a string, and the macro returns either True (if the file exists) or False (if it doesn't). This function works by using the Dir function, which checks for a file in a directory. If the file exists, then Dir returns the full path of the file.