File Exists on Disk
Function DiskFileExists(sFilePathAndName As String) As Boolean
‘Returns True if the file exists, False if it doesn’t
DiskFileExists = CBool(Len(Dir(sFilePathAndName)))
End Function
Daily posts of Excel tips…and other stuff
Function DiskFileExists(sFilePathAndName As String) As Boolean
‘Returns True if the file exists, False if it doesn’t
DiskFileExists = CBool(Len(Dir(sFilePathAndName)))
End Function
Posting code or formulas in your comment? Use <code> tags!
VERY NICE AND QUICK FUNCTION
THANKS
Very Elegant!