What would be the code to delete a workbook located here

C:\temp\Workbook.xls

Thanks,
Barb Reinhardt

make sure the workbook is closed

Kill "C:\temp\Workbook.xls"

--
regards,
Tom Ogilvy



"Barb Reinhardt" wrote:

> What would be the code to delete a workbook located here
>
> C:\temp\Workbook.xls
>
> Thanks,
> Barb Reinhardt

kill "C:\temp\Workbook.xls"

In article <29FFE9B3-697F-42A2-9969-(E-Mail Removed)>,
Barb Reinhardt <(E-Mail Removed)> wrote:

> What would be the code to delete a workbook located here
>
> C:\temp\Workbook.xls
>
> Thanks,
> Barb Reinhardt

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



"Barb Reinhardt" wrote:

> What would be the code to delete a workbook located here
>
> C:\temp\Workbook.xls
>
> Thanks,
> Barb Reinhardt

needs quotes around the argument.

In article <6AF8BADF-2428-4379-B94A-(E-Mail Removed)>,
Gary Brown <gary"DeleteThis2SendMeAnEmail".(E-Mail Removed)> wrote:

> Kill C:\temp\Workbook.xls

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)


"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:29FFE9B3-697F-42A2-9969-(E-Mail Removed)...
> What would be the code to delete a workbook located here
>
> C:\temp\Workbook.xls
>
> Thanks,
> Barb Reinhardt