figured it was something simple. If I may take a moment; I'd like to thak
you, and all of the other folks that utilize these discussion groups. Thanks
to you guys, my boss thinks I'm an Excel genius. Ya'll do good work. Happy
St. Patrick's Day.

"Tom Ogilvy" wrote:

Kill "C:\Myfolder\Myfile.xls"

will delete the referenced file (it should not be open).

It doesn't not put a copy in the recycle bin.

--
Regards,
Tom Ogilvy


"Johnny Mick" wrote:

Good Morning,
I'm not sure how to address my issue, without explaining in detail what I'm
trying to do (going to be a bit 'wordy'). I have a macro that pulls data
from our web-site, filters and formats the data and saves five separate
files, for further manipulation. After the final spreadsheet is populated
with the data needed for distribution, I'd like to somehow go back and delete
four of those 'saved' spreadsheets. How can I delete programmatically? More
than likely this is another simple task, which I'm just failing to realize.
Thanks in advance for any assistance provided.