Code request to delete files from folder

Hello friends,

I have several files in an ‘OUTPUT’ folder with different extensions as ‘docx, docm, pdf, xlsx … ‘. I have to delete some files which have extension ‘docx, xls … ‘ as per my requirement.

Please suggest me a code to delete the files in the folder as per my requirement.
First I want to select which format extension to delete and after selecting the format I want to delete the file with that selected extension automatically.

Any help will be highly appreciated.

Thanking you in anticipation.

Look at this link. Be sure to read it all the way to the end for alternatives.

http://www.rondebruin.nl/win/s4/win004.htm

Hello mso3,

This is simple to do. Here is a macro that will let you assign the file types you want to delete. If you have any questions, please ask.

Please Login or Register  to view this content.

Hello Leith Ross,

Greetings from me!

Excellent! Perfect solution.

It's working fine but I want a little revision in it as:
Now we have to type the file format extension in the code to delete the files; instead of it I want a dialog box to ask the format extension to delete. Because sometimes I don't want to delete the files of any particular format, for ex. now if I want to keep .xlsx extension files but the code deletes it because we have type it in the code. So to avoide this problem I need a dialog box to ask which file extension do you want to delete?

Thank you.

Hi Alan,

Thank you for an informative site to learn a lot.

I found it very useful.

Thank you and have a nice day.

Hello mso3,

Do you want a dialog with check boxes? This would help prevent errors due to typing.

Ok, no problem.

Thank you.

Hello mso3,

The attached workbook has a UserForm, Standard VBA Module and a Class Module. All of these provide a user interface for selecting the folder and file types to be deleted.

I know this is a lot more that what you asked for. Deleting files requires safeguards to prevent accidental deletion of files. A simple dialog box can not provide that protection.

You can add more file types to the UserForm if needed. If you are unsure how to do this, let me know and I can guide through the process.

Hi Leith Ross,

Greetings from me!

Please insert a dialog box to our first program to ask which file format do you want to delete and problem will be solved.
Sorry for trouble.

Have a nice day.

Hello mso3,

Try this version and let me know if it needds any changes.

Please Login or Register  to view this content.

Hello Leith Ross,

Excellent! Perfect solution. It's working fine as per my requirement.

Thanks for taking extra trouble for me.

Have a nice time.

Hello mso3,

You're welcome.