Delete excel spreadsheet from code.

[marathonlady]

How do I delete an excel spreadsheet via code? I run a query that creates the spreadsheet, but when I run it again it will not overlay the spreadsheet, it makes a second copy. I either need code to delete before I create, or overlay it. I am using the TransferSpreadsheet method of the docmd.

Thanks for for any help.

 

[Jacob Mathai]

I will delete the excel file before I do a Transferspreadsheet.

Dim delfile
On error resume next
docmd.setwarnings false
delfile = "d:\data\excel\myfile.xls"
kill delfile

Docmd.transferspreadsheet .................

docmd.setwarnings true

Note : If the file does not exist, you will not get error message, because of 'On error resume next'