xl vba check for folder code example

Example: xl vba check for folder

Public Function IsDir(s)
    IsDir = CreateObject("Scripting.FileSystemObject").FolderExists(s)
End Function