Deleting Workbook

[Guest]

What would be the code to delete a workbook located here

C:\temp\Workbook.xls

Thanks,
Barb Reinhardt

 

[Guest]

make sure the workbook is closed

Kill "C:\temp\Workbook.xls"

 

[JE McGimpsey]

kill "C:\temp\Workbook.xls"

 

[Guest]

Kill C:\temp\Workbook.xls
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

 

[JE McGimpsey]

needs quotes around the argument.

 

[Chip Pearson]

Barb,

You can use the Kill method to permanently and completely delete the file:

Kill "C:\Temp\Workbook.xls"

Note that Kill does NOT send the file to the Recycle Bin. The file is gone
forever. If you want to recycle the file, see
http://www.cpearson.com/excel/recycle.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)