vba code to loop through desktop, folder & subfolders to kill specific file extensions .

[JEAN1972]

How to loop through desktop , folder and subfolder to kill all *.xlsx files.

The latter is C:\Users\User1\Desktop there are many folders with one level subfolders.

That is all extensions with *.xlsx on desktop, folder and subfolders of desktop of one level

Can anyone assist

[Leith Ross]

Hello Jean1972,

This macro will allow you to delete any file by full or partial name or file extension.

Add a new VBA module to your workbook and copy the macro code into it. There is an example macro that deletes all xlsx files on the Desktop and in all folders and subfolders. You can control the subfolder search depth to whichever level you want. See the comments in the macro.

Delete Files Macro

Please Login or Register  to view this content.

Example Macro

Please Login or Register  to view this content.