Kill "X:\Myfiles\*.txt"

Anyway, look at the Kill command - after the files are closed.

Kill doesn't put files in the recycle bin. It deletes them and they are
gone - so test, then use carefully.

Regards,
Tom Ogilvy


"Rohit Thomas" wrote in message
...
Hello All,

I have delimted text files that I import into Excel using
macros. Once the import is finished, I would like to
delete the text file because it contains SS#'s and other
sensitive info. How do I delete the file from Excel using
VB? The text files are normally located on a LAN.

Thanks in advance,
Rohit Thomas