Excel VBA Check if directory exists error
To check for the existence of a directory using Dir, you need to specify vbDirectory as the second argument, as in something like: If Dir(“C:\2013 Recieved Schedules” & “\” & client, vbDirectory) = “” Then Note that, with vbDirectory, Dir will return a non-empty string if the specified path already exists as a directory or … Read more