Excel tip: Check if a directory existsDate: 9 june 2001This function will return TRUE if the specified folder/direcotry exists, or FALSE if it doesn't. Copy-paste friendly code: Public Function CheckDir(Directory As String) As Boolean
On Error GoTo ErrNotExist ChDir (Directory) CheckDir = True Exit Function ErrNotExist: CheckDir = False End Function « back | ||
Home
Privacy Policy
Cookie Policy
EULA
Sitemap
Search
List of all utilities
Printer friendly page
Contact Us
^ Back to Top
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
![]() ![]() |