I am using this Function to test if files exist in many cases. It has always worked for me in the past but now it will not work on Hidden files (I never used it on hidden files in the past).
Public Function fnFileExists(strFullPath As String) As Boolean
'Macro Purpose: Check if a file or folder exists
On Error GoTo EarlyExit
If Not Dir(strFullPath, vbDirectory) = vbNullString Then fnFileExists = True
EarlyExit:
On Error GoTo 0
End Function
Is there a way I can modify this so it works on both Hidden and Visible files within Hidden or Visible folders?
Bookmarks