Deleting an xls file using VBA

[lj50v]

As part of a small application where I open a number of different files and extract some data, I then save the newly created sheet.

As the VBA code is static in this sense, I need to be able to delete the newly created file.

If the processed file is opened using -
Workbooks.Open Filename:=FileToOpen

How do/can I delete a file when I no longer need it, and is it possible to NOT be prompted as to whether I'm sure I want to do this? !!

Many thanx in advance

 

[macropod]

Hi lj50v,

If you haven't saved the newly created workbook, all you need to do is to close it without saving - there is no file to delete.


Cheers
[MS MVP - Word]

 

[lj50v]

Thanks for that, but as part of the process I do save the file as I need to keep the new information. As that is the case I can always save it in a different location, but it doesn't stop the fact that I would still like to be able to delete a/the file on the fly.

Seeing that Activate, Close, SaveAs are all there as part of Workbooks or ActiveWorkbook, what do we do to Delete?

Many thanx

 

[PHV]

Kill "\path\to\file.ext"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886