VB equivalent

[Dave]

Hi all,
Can anybody please tell me the VB equivalent for IF EXIST?
Basically, I need to determine if a file exists on a users
home drive. If so, KILL the file then FILECOPY a new one,
if not show a MSGBOX.
I've got all the code sorted out, except for this part.
Thanks in advance.
Dave

 

[Graham R Seach]

Dave,

If Dir(strPath, vbNormal) <> "" Then
'File exists
Else
'File doesn't exist
End If

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Dave]

Thanks Graham.
I overlooked the dir function.
Cheers,
Dave

 

[Chris Nebinger]

You can also just kill the file, then trap the error and
ignore it.


Chris Nebinger