Code for deleting a file on hard drive

[steve728]

Please give me a sample of the vba code I would use to delete a file located at C:\Program\Data\repair.txt.

I don't want to use the interface. I want delete from code.

Thank you!

Steve

 

[steve728]

Also,please, how do I delete a table from my mdb using vba code.

Thanks,

STeve

 

[cehepker]

In reply to your second question: are you in an mdb or an adp? If you are in an adp, then you use the SQL command "Drop Table" where table is the name of the table you want to delete. Using the fully qualified name of the table is the best course to follow.

 

[MattJW]

To Delete a File from a directory...

dim strFile as String
strFile = "C:\Program\Data\repair.txt"

If Dir(StrFile) Then 'Check to see if file exists
Kill strFile
End If

Hope this helps!