delete spreadsheet

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[AndyC812]

Can this be done with a variable instead of the explicit path in quotes? I
assume so - like this:
Kill PathToMyFile

 

[Dave Peterson]

Yep.

Can this be done with a variable instead of the explicit path in quotes? I
assume so - like this:
Kill PathToMyFile

 

[AndyC812]

OK. It's giving me an error saying action not allowed or something like
that. I think it is because the file is linked to an open Word file. I
haven't been able to figure out how to close that Word file yet. I have a
separate question on the board for that one.

I suspect if that file is closed I can delete the data file, no problem.