Excel 2010 vba delete files in folder

Valli is sharing useful VBA examples ad Tips to helps us automating daily tasks. Related Posts. August 6th, 0 Comments. July 6th, 0 Comments. July 5th, 1 Comment. Show or Hide Unload a userform. October 2nd, 1 Comment. Thanks in advance for your assistance Fermin Bas. Hi, what if I want to delete all files in a folder older then 30days, how is this possible?

Thanks for your info, this success in my work… thansk very much. Clear End Sub. Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Toggle navigation. Leave a Reply Cancel reply Your email address will not be published. Continue 1 Comment. Continue No Comments. Continue 5 Comments. Continue 10 Comments. Terms and Conditions of use. Home About Advertise With Us. Newsletter Get latest updates from exceltip in your mail.

It has a DeleteFile method and a FileExists method. See the MSDN article here. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 13 years, 4 months ago. Active 3 months ago. Viewed k times. Using VBA, how can I: test whether a file exists, and if so, delete it?

Add a comment. Active Oldest Votes. EDIT: Marking this answer as community wiki so anyone can modify it if need be. You can't have two files with the same name in a directory.

FileExists yourFilePath Then. Mike Woodhouse Mike Woodhouse Using this syntax without declaring a file scripting object, must add reference for Microsoft Scripting Runtime, else: Dim fs As New Scripting.

FileSystemObject — pghcpa. Since there's no variable to set to Nothing, is there a risk the FileSystemObject will remain in memory, causing a leak or other issue? No, it will be discarded after the "End With". Since it is not assigned to a variable the effect is similar to the object having been assigned to a variable that has been set to "Nothing".

Dan Donoghue Dan Donoghue 5, 1 1 gold badge 16 16 silver badges 36 36 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.