In this article I will explain how you can delete files using VBA. – Basics: The code below will delete the file specified by the path associated to the variable strPath: Sub Example1() Dim ObjFso As Object Dim strPath As String ‘file path strPath = “D:StuffBusinessTempTempFile.xlsx” Set
In this article I will explain how you can check if a file exists using VBA. Lets say we have the file “TempFile.xlsx” in the path “D:StuffBusinessTemp”: The code below will check if the file with the full path “D:StuffBusinessTempTempfile.xlsx” exists or not. An appropriate message
Previously in the article Find and List All Files and Folders in a Directory I’ve explained how you can list all the files in a folder using VBA for Excel. In this article I will explain how you can use VBA to list all the files