does a file exist?
"nath" <n@n wrote in message ...
Is there any way of checking to see if a file exists? So
if it doesnt i can generate it.
TIA
Nath
Use the Dir Function
string=Dir(pathname,attributes)
Where
string is the returned name, null if no match found
pathname = the drive\directory name (wildcards allowed)
attributes is an optional argument specifying the
type of file to list
vbNormal (Default) Specifies files with no attributes.
vbReadOnly Specifies read-only files in addition to files with no
attributes.
vbHidden Specifies hidden files in addition to files with no
attributes.
VbSystem Specifies system files in addition to files with no
attributes. Not available on the Macintosh.
vbVolume Specifies volume label; if any other attributed is specified
vbDirectory Specifies directories or folders in addition to files with
no attributes
Keith
|