View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Deleting a file via a macro

You need to use the kill function...

Kill "C:\StoreTabFile.XLS"

--
HTH...

Jim Thomlinson


"Sarah at DaVita" wrote:

I need to delete a file before I start up a macro. I want to just have this
as part of the macro I run. I don't understand how to use the deleteFile
method. The file I want to delete is C:\StoreTabFile.XLS. The help screen
mentions a FileSystemObject but I do not know what that is. Can someone help
me out?