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