Deleting several files within one folder

[JPDutch]

I'm trying to create a macro that will delete several files within the same folder. I use the following to delete the file 1_OSHA LOG_2012 .xls:

Please Login or Register  to view this content.

However, I need a macro that will allow me to delete many files within the same folder, for example:

1_OSHA LOG_2012 .xls
10_OSHA LOG_2012 .xls
11_OSHA LOG_2012 .xls
12_OSHA LOG_2012 .xls
13_OSHA LOG_2012 .xls
38_OSHA LOG_2012 .xls
110_OSHA LOG_2012 .xls
815_OSHA LOG_2012 .xls

Is this possible? If so, I would appreciate any help you can provide to me. JPDutch

[NickyC]

Hi
enter your file names in a range in the worksheet (I've specified A1:A8 in this example) and try this macro:

Please Login or Register  to view this content.

[xladept]

If that code works then maybe this?

Please Login or Register  to view this content.

[JPDutch]

The "file names in a range" macro did it! Thank you very much NickyC.

[JBeaucaire]

A little trick to make the "range" dynamic. Assuming all the strings are typed into those cells in column A and not formulaic, this will grab all those cells, however many there are, ignoring blank cells:

Please Login or Register  to view this content.