Hi ,

I have .xls files in a folder ( around 100+ excel files).each xls has 20 worksheets . I need to delete all the worksheets from all the xls files except the work sheet by name sheet1. is there a way I can do it in single shot,instead of doing it manually for each xls???

Thx,Deepti