Answers for "vba check if file exists"

vba check if file exists

Public Function IsFile(s)
    IsFile = CreateObject("Scripting.FileSystemObject").FileExists(s)
End Function

Posted by: Guest on April-03-2020

excel vba check if directory exists

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

Posted by: Guest on April-03-2020

Code answers related to "vba check if file exists"