vba check if file exists excel vba check if directory exists

The solution for “vba check if file exists excel vba check if directory exists” can be found here. The following code will assist you in solving the problem.

Public Function IsFile(s)
IsFile = CreateObject(“Scripting.FileSystemObject”).FileExists(s)
End FunctionPublic Function IsDir(s)
IsDir = CreateObject(“Scripting.FileSystemObject”).FolderExists(s)
End Function

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts