File path

Alain · Jan 10, 2006

Happy new year to all,

I am wondering if it is possible from Access 2000 to find out if a Excel
file exist and to delete it if it does.
If so then how should I do this ??

Thanks

Alain

Klatuu · Jan 10, 2006

To determine if the file exists, use the Dir() function
To delete it, use the Kill statement
You can find info on both in VBA Help.

Alain · Jan 11, 2006

Thanks,

I'll look it up

Alain

Klatuu said:
To determine if the file exists, use the Dir() function
To delete it, use the Kill statement
You can find info on both in VBA Help.