Question: how to check if file exists in directory vba?
Answer: Using the Dir Command to Check If a File Exists Then we use the Dir function to get the file name into the variable strFileExists. If the file exists in the directory, its name will be assigned to the variable strFileExists. If it does not exist then strFileExists will remain blank.