Skip to content

Instantly share code, notes, and snippets.

@hughlilly

hughlilly/CheckExists.vba

Last active December 14, 2021 01:23
Show Gist options
  • Save hughlilly/a4d1d705ab43db8129c129785eb4a4ed to your computer and use it in GitHub Desktop.
Save hughlilly/a4d1d705ab43db8129c129785eb4a4ed to your computer and use it in GitHub Desktop.
Download ZIP
Check file/dir exists in MS Excel
Raw
CheckExists.vba
' From https://stackoverflow.com/questions/67066414/
Public Function checkExists(fPath As String) As Boolean
If fPath <> "" Then
If Dir(fPath, vbNormal + vbDirectory) <> "" Then
checkExists = True
End If
End If
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment