DELETE AN EXCEL WORKBOOK

[dmhehir]

How does one Delete an Entire Workbook as opposed to a Worksheet

 

[macropod]

Hi Don,

You could select the file using:
.. File|Open from within Excel; or
.. Windows Explorer,
and press the delete button ...

 

[FSt1]

hi
close the workbook. then in the file open dialog, select the file and hit
the delete key. you will be asked to confirm. click yes. file gone to recycle
bin.

regards
FSt1

 

[dmhehir]

Thanks - Worked like a charm
--
Don

hi
close the workbook. then in the file open dialog, select the file and hit
the delete key. you will be asked to confirm. click yes. file gone to recycle
bin.

regards
FSt1

 

[Don Guillett]

Here is one I have assigned to a custom toolbar button

Sub KillActiveWorkbook()
With ActiveWorkbook
mb = .Name
.Close
End With
MyAnswer = MsgBox("Do you want to KILL this file?", vbYesNo)
If MyAnswer = vbYes Then Kill mb
End Sub