Excel tip: Check if a directory exists
Date: 9 june 2001This function will return TRUE if the specified folder/direcotry exists, or FALSE if it doesn't.
Copy-paste friendly code:
Public Function CheckDir(Directory As String) As Boolean
On Error GoTo ErrNotExist
ChDir (Directory)
CheckDir = True
Exit Function
ErrNotExist:
CheckDir = False
End Function
On Error GoTo ErrNotExist
ChDir (Directory)
CheckDir = True
Exit Function
ErrNotExist:
CheckDir = False
End Function
« back