There are a few ways to determine if a file exists in Excel. One way is to use the FILEEXISTS function. This function takes a filename as an argument and returns TRUE if the file exists or FALSE if it does not exist.

Another way to determine if a file exists is to use the GetFileAttributes function. This function takes a filename as an argument and returns a value that can be interpreted as follows:

• -1: The file does not exist.
• 0: The file exists but is not accessible (e.g., it is open by another process).
• >0: The file exists and is accessible.

Note: If you are running Excel on Windows NT, you must have administrator privileges to use the GetFileAttributes function.