Deleting a file via a macro

  • Thread starter Thread starter Sarah at DaVita
  • Start date Start date
S

Sarah at DaVita

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?
 
VB has a Kill command that you should be able to use. Try this line...

Kill "C:\StoreTabFile.XLS"
 
What do I put in there to tell the macro to continue if it cannot find the
file to kill?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete a macro using a macro 4
Macro to Delete the last N rows 9
macro to delete another macro 1
Movinf files to recycle bin 4
'Cannot insert object' message when I try to put a button on a worksheet 7
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Run Macro If Cell have "x" value 0
Macro warning despite no macros in document 1

Back
Top