Kill/Delete file in current path

[LNG2013]

I have a file, test.csv, that is in the same folder as my macro.xls.
How do I delete the test.csv, without using the full path extension. This macro runs on computers with different path setups.

 

[wigi]

Kill Thisworkbook.Path & "\test.csv"

 

[kpark91]

Check this wesite:
http://www.cpearson.com/excel/recycle.aspx
http://www.rondebruin.nl/folder.htm

This will return your workbook directory in any computer or path

ThisWorkbook.Path

Please remember to add "\test.csv" to refer to a file instead of a folder.


Lastly, using KILL will permanently delete your file and cannot undo it.

 

[LNG2013]

Kill Thisworkbook.Path & "\test.csv"

This worked for me! Awesome! Thanks for your help!

 

[Theglyde]

I am doing this, it deletes my workbook that I said to kill, my problem is that in the new save path that I have, I am still using that macro to save my files and changes I make but that last line comes up still giving me error 53 that the kill statement is impossible since the template was already deleted. I want to know how can I make the if statement or Error 53 code that just ignores this Kill code if file not found and not give me and error code