DELETE AN EXCEL WORKBOOK

  • Thread starter Thread starter dmhehir
  • Start date Start date
Hi Don,

You could select the file using:
.. File|Open from within Excel; or
.. Windows Explorer,
and press the delete button ...
 
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
 
Thanks - Worked like a charm
--
Don


FSt1 said:
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
Click to expand...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
I can only delete an entire row not a cell in excel 2013? 1
Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Name an Entire Workbook 3
Excel VBA 0
can I change page layout in an entire existing Excel workbook? 2
Print Entire Workbook acting strangely 1

Back
Top