Tag Archives: Files

No Thumbnail

VBA Delete File

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

No Thumbnail

VBA Check File Exists

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

privacy policy