SyntaxFix

[vba] Deleting a file in VBA

1.) Check here. Basically do this:

Function FileExists(ByVal FileToTest As String) As Boolean
   FileExists = (Dir(FileToTest) <> "")
End Function

I'll leave it to you to figure out the various error handling needed but these are among the error handling things I'd be considering:

  • Check for an empty string being passed.
  • Check for a string containing characters illegal in a file name/path

2.) How To Delete a File. Look at this. Basically use the Kill command but you need to allow for the possibility of a file being read-only. Here's a function for you:

Sub DeleteFile(ByVal FileToDelete As String)
   If FileExists(FileToDelete) Then 'See above          
      ' First remove readonly attribute, if set
      SetAttr FileToDelete, vbNormal          
      ' Then delete the file
      Kill FileToDelete
   End If
End Sub

Again, I'll leave the error handling to you and again these are the things I'd consider:

  • Should this behave differently for a directory vs. a file? Should a user have to explicitly have to indicate they want to delete a directory?

  • Do you want the code to automatically reset the read-only attribute or should the user be given some sort of indication that the read-only attribute is set?

EDIT: Marking this answer as community wiki so anyone can modify it if need be.

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to file-io

• Python, Pandas : write content of DataFrame into text File • Saving response from Requests to file • How to while loop until the end of a file in Python without checking for empty line? • Getting "java.nio.file.AccessDeniedException" when trying to write to a folder • How do I add a resources folder to my Java project in Eclipse • Read and write a String from text file • Python Pandas: How to read only first n rows of CSV files in? • Open files in 'rt' and 'wt' modes • How to write to a file without overwriting current contents? • Write objects into file with Node.js

Examples related to delete-file

• Ansible: How to delete files and folders inside a directory? • Can I delete data from the iOS DeviceSupport directory? • Python3 project remove __pycache__ folders and .pyc files • How do I delete files programmatically on Android? • Delete files or folder recursively on Windows CMD • How to delete a folder and all contents using a bat file in windows? • How to delete a file or folder? • How to remove a directory from git repository? • Linux delete file with size 0 • Java 'file.delete()' Is not Deleting Specified File

Examples related to file-exists

• Portable way to check if directory exists [Windows/Linux, C] • VBA check if file exists • How to check if a file exists from a url • check if file exists in php • How do I check if a file exists in Java? • Verify if file exists or not in C# • How do I check whether a file exists without exceptions? • Deleting a file in VBA