Vba check if file exists Code Example - Coding

vba check if file exists

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

excel vba check if directory exists

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

Related
export datagridview to excel vb.net Code Example
vba array length Code Example
string to date vb Code Example
vba copy paste value only Code Example
excel-vba how to convert a column number into an excel column Code Example