DELETE AN EXCEL WORKBOOK
 

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

DELETE AN EXCEL WORKBOOK
 

Hi Don,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"dmhehir" wrote in message ...
How does one Delete an Entire Workbook as opposed to a Worksheet
--
Don

DELETE AN EXCEL WORKBOOK
 

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" wrote:

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

DELETE AN EXCEL WORKBOOK
 

Thanks - Worked like a charm
--
Don


"FSt1" wrote:

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" wrote:

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

DELETE AN EXCEL WORKBOOK
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dmhehir" wrote in message
...
How does one Delete an Entire Workbook as opposed to a Worksheet
--
Don