Answers for "excel vba how to check if a 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 existence of a file

' Existence of a file 
If Dir("C:myDirectorymyFile", vbDirectory) = vbNullString Then
    MsgBox "Doesn't exists"
Else
    MsgBox "Exists"
End If

Posted by: Guest on January-14-2021

Code answers related to "excel vba how to check if a file exists"