Checking to see if a file exists on c: drive

[KimberlyC]

Hi
I need to run code that checks if a an excel file exists on the c: drive. I
don't know how to do this.....

Any help on how to do this would be greatly appericated.

Thanks in advance,
Kimberly

[Bruce M. Thompson]

> I need to run code that checks if a an excel file exists on the c: drive. I
> don't know how to do this.....

Try something like this:

If Len(Dir$("c:\My Documents\MyFile.doc",vbNormal) & "") > 0 Then
'File exists
Else
'File doesn't exist
End If

For more information, see "Dir()" in Access VBA Help.

--
Bruce M. Thompson, Microsoft Access MVP
bthm...@mvps.org (See the Access FAQ at http://www.mvps.org/access)
>>No Email, Please. Keep all communications
within the newsgroups so that all might benefit.<<