Deleting a Workbook

[MartyF]

I have a spreadsheet that runs 10 scenarios and after each scenario
rename the workbook and save it.

Do you know a way to

1. Check to see if a workbook already exists in my work directory, and

2. If so, how can I delete it

 

[Bernie Deitrick]

MArty,

On Error Resume Next
Kill "C:\Folder Name\File to Delete.xls"

HTH,
Bernie
MS Excel MVP