File path

[Alain]

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

 

[Guest]

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]

Thanks,

I'll look it up

Alain

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.