how to check if a directory exists in excel vba?
Using the Dir Command to Check If a Folder Exists Then we use the Dir function to get the file name into the variable strFileExists. In order to check a folder, we need to add the second argument to the function – vbDirecotry.