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

Paul,

You can use File System Objects to do this.  You will need to set a
reference in code to 'Microsoft Scripting Runtime'.


Dim fso As FileSystemObject

Set fso = CreateObject("Scripting.FileSystemObject")

If fso.FileExists("[Full Path To File]") = True Then
	'-- take action
End If

The help file for FSO is Script56.chm, but you may have to download it.

Best of Luck,
Dan Waters



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Tuesday, June 29, 2004 3:01 AM
To: accessd
Subject: [AccessD] Check If File Exists In Directory - Cant Think

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

-- 

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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com