Deleting Files from Within an Excel Macro
 

I have gotten stuck on trying to delete an ascii file from within an Excel Macr

I have a file in EX: "P:\temp\9.dat" that I would like to delete so that I can rename a temporary file to replace this one

Thanks

Cha

Deleting Files from Within an Excel Macro
 

Chad,

Use Kill to permanently and irrevocably delete the file. E.g.,

Kill "P\temp\9.dat"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Chad B" wrote in message
...
I have gotten stuck on trying to delete an ascii file from within an Excel
Macro

I have a file in EX: "P:\temp\9.dat" that I would like to delete so that
I can rename a temporary file to replace this one.

Thanks,

Chad