logo ASAP Utilities

Excel tip: Check if a directory exists

Date: 9 june 2001

This 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
      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 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook