Good morning, all,

Nice easy one for you all.

Is it possible to delete a workbook from a disk using VBA?
I tried to record myself doing it, with File Open, right clicking a
workbook, then clicking "Delete", but all I got was a CHDir Command.

Thanks in advance

pete

You can use the Kill statement to do this:

Kill "C:\myfolder\myfile.xls"

This will throw an error if the file doesn't exist, or if it can't be
deleted
for some reason (e.g. read-only or in use), so you might want to put
in some error-handling.

Andrew Taylor


Peter Rooney wrote:
Good morning, all,

Nice easy one for you all.

Is it possible to delete a workbook from a disk using VBA?
I tried to record myself doing it, with File Open, right clicking a
workbook, then clicking "Delete", but all I got was a CHDir Command.

Thanks in advance

pete

Andrew,

Just the job.

Thank you!

Pete



"Andrew Taylor" wrote:

You can use the Kill statement to do this:

Kill "C:\myfolder\myfile.xls"

This will throw an error if the file doesn't exist, or if it can't be
deleted
for some reason (e.g. read-only or in use), so you might want to put
in some error-handling.

Andrew Taylor


Peter Rooney wrote:
Good morning, all,

Nice easy one for you all.

Is it possible to delete a workbook from a disk using VBA?
I tried to record myself doing it, with File Open, right clicking a
workbook, then clicking "Delete", but all I got was a CHDir Command.

Thanks in advance

pete

"Peter Rooney" wrote:

Good morning, all,

Nice easy one for you all.

Is it possible to delete a workbook from a disk using VBA?
I tried to record myself doing it, with File Open, right clicking a
workbook, then clicking "Delete", but all I got was a CHDir Command.

Thanks in advance

pete