Deleting and Excel workbook from with in VBA.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Databaser - 09 Sep 2005 01:26 GMT

I need to know the VBA code for deleting an Excel workbook.

Problem: I create a Excel workbook to attacht to an email. This works
great. However, when I try to overwrite it with the next workbook it is hit
of miss if it will do it. So, I want to delete the workbook after I have
sent it out and before the next workbook is created. Can anyone help?

Reply to this Message

Ken Snell [MVP] - 09 Sep 2005 01:39 GMT

Kill "C:\MyFolder\MyFilename.xls"

Signature

Ken Snell
<MS ACCESS MVP>

>I need to know the VBA code for deleting an Excel workbook.
>
[quoted text clipped - 3 lines]
> of miss if it will do it. So, I want to delete the workbook after I have
> sent it out and before the next workbook is created. Can anyone help?

Reply to this Message