If you want to permanently and completely delete the file, use the Kill
statement. Note that Kill does not send the file to the Recycle Bin. The
file is gone forever. If you want to delete the file, but put it in to the
Recycle Bin, use the code on http://www.cpearson.com/excel/recycle.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"aidan" wrote in message
...
How to delete a file in code? I dont want to be asked if i wanted or not
to
do it