Need a little help with batch file

**BlueGrimRX8** · 01-11-2005, 10:33 AM

I am trying to write a batch file that looks in all the directories withing a folder and deletes all the .xls files in all the folders.
So I have folder structure
Main Directory
-Dir 1
-Dir 2
-Dir 3

Inside each of those Dir's there are .xls files. I want to delete all of them, could someone help me write a batch file to do this?

Thanks!!

**eleventh** · 01-11-2005, 10:59 AM

Originally Posted by BlueGrimRX8

I am trying to write a batch file that looks in all the directories withing a folder and deletes all the .xls files in all the folders.
So I have folder structure
Main Directory
-Dir 1
-Dir 2
-Dir 3

Inside each of those Dir's there are .xls files. I want to delete all of them, could someone help me write a batch file to do this?

Thanks!!

cd \"Main Directory" (quotes not needed if directory name has no spaces)

cd "dir 1"
del *.xls /q
cd..
cd "dir 2"
del *.xls /q
cd..
cd "dir 3"
del *.xls /q
cd..
exit

Hope that helps

**paulpitchford** · 01-11-2005, 11:02 AM

cd\yourdirectory <------ This is the root of your directory structure
del *.xls /s

Put that in your batch file and it should work.

Thanks,

Paul.

**BlueGrimRX8** · 01-11-2005, 11:07 AM

Thanks paul thats exactly what I was looking for. Eleventh, that would have worked to but I have over 2000 subdirectories.

Thanks guys knew somebody could help!!

**eleventh** · 01-12-2005, 07:10 AM

Originally Posted by BlueGrimRX8

Thanks paul thats exactly what I was looking for. Eleventh, that would have worked to but I have over 2000 subdirectories.

Thanks guys knew somebody could help!!

Gotcha - I didn't know if there were some directories in Yourdirectory that you didn't want to delete the .xls's in, that's why I didn't reccommend /s. Happy coding.

Incidentally, if you want to turn your bacth file in to an exe check this out: http://www.bdargo.com/index.htm