Thread: Error Message
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Error Message

Hi,

I have code that checks if a folder exists

strFullPath = "D:\Release"

Sub FolderExistCheck(strFullPath As String, Exists As Boolean)
'if Exists = True then the path exists
If Not Dir(strFullPath, vbDirectory) = vbNullString Then Exists = True
If strFullPath = "" Then Exists = False
End Sub

"D:\Release" does not exist but instead of returning "False" it returns
Bad filename or number. But this only happens with the D: directory if the
directory starts with C: it returns false. Does anyone know why this is?

Thanks