Is there a way to use code in access to delet a file?
I have set up code to transfer a query to am excel workbook and format the sheet. but in the process excel creates a backup copy in the same folder. Is there a way to either not create the backup copy or delete it, without opening the folder selecting the file and deleting.