Delete workbook

[Ed]

I have a macro which has copied data from a workbook, I now want the macro
to delete the entire workbook (send it to the recycle bin) but can't figure
out how to do it. Can someone please help me with this problem.

 

[Patrick Molloy]

KILL "path"

 

[Rick Rothstein]

Just so the OP knows, Kill doesn't send the file to the Recycle Bin (as the
OP indicated he wanted)... it permanently removes the file from the drive.

 

[Rick Rothstein]

If the OP wants to use the Recycle Bin, there is an API solution to do so.
There is an example of how to do this here...

http://vbnet.mvps.org/code/shell/recyclebin.htm

If the OP needs help breaking this apart for his own needs, he should post
back to this thread and someone here will assist him.

 

[Ed]

Thanks Patrick, it works great.

KILL "path"

 

[Ed]

Thanks Guys - I don't really care what happens to the file. Appreciate all
your help - working fine.