I took Tom's code and converted it to a function...figured I'd post it in case anyone might be looking. This function will return True if the file with FileName exists, and false if it does not. Function CheckForFile(FileName As String) As Integer Dim FileDir As String CheckForFile = False FileDir = Dir$(FileName, 0) If Len(FileDir) > 0 Then CheckForFile = True End If End Function Kevin
Return to top
. . . . CheckForFile Function (Kevin Pettitt 8.Feb.07)
Print this page
