Macro to delete a workbook.

[John Baker]

Hi:

I need to save some data in a special workbook, save the workbook (with a new name), then
e mail the workbook and delete the saved workbook.

I can do all this except the last step.

I want to delete the saved workbook (which is not the one containing the macro) with no
question or message to the end user.

Anyone know of a method?

Regards

John Baker

 

[Chip Pearson]

John,

You can use the Kill statement to permanently delete a file. For
example,

Kill "C:\Test\Book1.xls"

Note that Kill does not put the file in the Recycle Bin. To
delete a file to the Recycle Bin, see
www.cpearson.com/excel/recycle.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Hi:

I need to save some data in a special workbook, save the

workbook (with a new name), then

 

[John Baker]

Chip:

Thanks..works like a charm!

John

 

[MSP77079]

Command to delete a file is:

Kill ThisFileName

where ThisFileName is the complete path