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 does'nt.


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
Share this page:
Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - 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