Excel VBA: Determining whether a path exists

To check whether a path exists or not, we can use Excel VBA's GetAttr function. The following function returns True if a specified path exists, and return False otherwise:

Function isPathExist(ByVal pathname As String) As Boolean
 On Error Resume Next
 isPathExist = GetAttr(pathname) And vbDirectory = vbDirectory
End Function

Related posts:

• Excel VBA Macro Examples: Sub Procedure
• Excel VBA Macro Tutorial: Controlling Execution
• Determinig whether a file exists

---
If you like posts in this blog, you can to support me :)