Modify / Delete files via VBA

[BanditLV]

Is there a way to delete / rename files through VBA? For instance, I have a file C:\Progra~1\RPS\harbour.dbf that I want to delete because I'm getting ready to overwrite it utilizing another program within Access - each time I use the program, it adds another file called harbour1.dbf or harbour2.dbf and so on... This is basically to maintain system integrity and illiminate garbage files...

All help would be extremely appreciated...

 

[Durkin]

Look up the 'Kill' function for deleting files. Durkin

 

[RickSpr]

Also, look up the Name statement to rename files:

Name oldpath As newpath