"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