Loop through folder and delete all files that meet criteria

[sharky12345]

Can someone show me how to loop through all of the files in a folder and delete any .xlsx files that have a filename which contains the string 'Demand Data'?

 

[RoryA]

No real need to loop:

shell "cmd /k del ""C:\testing\*demand data*.xlsx""",vbHide

should do the job. Amend folder as required.

 

[sharky12345]

Thanks Rory!