How to check if a folder path exists in Excel?

For checking if a folder path exists, you can try the method in this article.

Check if a folder path exists in Excel with User-defined function

Check if a folder path exists in Excel with VBA code

You can do as follows to check if a folder path exists.

1. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.

2. In the Microsoft Visual Basic for Applications window, click Insert > Module. And then copy and paste the below VBA code into the Code window.

VBA code: Check if path exists

Public Function CheckDir(Directory As String) As Boolean
    On Error GoTo ErrNotExist
    Call ChDir(Directory)
    CheckDir = True
    Exit Function
ErrNotExist:
    CheckDir = False
End Function

3. Press Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.

4. Select a blank cell, enter formula =CheckDir(A2) into the Formula Bar, and then press the Enter key.

Note: A2 is the cell contains the folder path you will check.

If the folder path exists in your computer, you will get a TRUE result. Otherwise, it will display the FALSE result.