Check if a folder path exists on your PC using Excel VBA

Do you need to verify whether a folder path exists on your computer using Excel? This guide explains how to use a custom VBA function to check folder paths and return TRUE or FALSE based on their validity.

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 is accessible on the local file system.

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". Then, copy and paste the following 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 this formula into the Formula Bar, and then press the "Enter" key.

=CheckDir(A2)

Note: A2 is the cell that contains the folder path you want to check.

If the specified directory is accessible on the local file system of the computer where Excel is running, you will get a "TRUE" result. Otherwise, it will display the "FALSE" result.