Hi, want to know if there is a way to delete an existing file in excel that i export out of my access DB? What i am trying to do is, export many queries to excel worksheets in one excel workbook (i have this part working fine and its creating a spreadsheet and formatting it and putting it out on the C drive) and then when the user is done reviewing the spreadsheet and hits the "X" button (or exits excel) on the spreadsheet it would close excel and delete that file on the c drive. Is this doable? is there a code i can use?
thank you,
Summer
thank you,
Summer