Deleting Files from Within an Excel Macro

C

Chad B

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
 
C

Chip Pearson

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 said:
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
Click to expand...
I can rename a temporary file to replace this one.
 
Top