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

Thanks.....I know it's Tuesday but it's as if it's a monday morning moment...





Message date : Jun 29 2004, 09:15 AM
>From : "Gustav Brock" 
To : "Access Developers discussion and problem solving" 
Copy to : 
Subject : Re: [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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm