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 Function3. 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.
Best Office Productivity Tools
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
