Deleting Files from Within an Excel Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top