[AccessD] Check If File Exists In Directory - Cant Think

Hi paul

That would be

  If Len(Dir("C:\Branston\OWP_Template.xls", vbNormal)) > 0 then
    ...
  End If

/gustav


> To all,
 
> I hate to ask this but I can’t for the life of me think of the command to use to check if a file exists within a certain directory.  Basically I just need to check if OWP_Template.xls exists in the
> directory C:\Branston\
 
> Thanks for all your help
..
 
> Paul Hartland
 
> P.S. Feel free to come out with silly comments like you should change career to something like a bin man etc
..ha ha