Delete one sheet from 2000+ workbooks.

**Backlash** · 10-09-2012, 11:51 AM

I have around 2000 reports that all have a one sheet with the same name I need to be removed per a client’s request.
a)I was wondering if there is a macro that will allow me delete a specified sheet on all workbooks within a folder.

(I think the thread I have attached deletes a sheet but I am a bit of a novice and have not been able to get it to work properly.

http://www.excelforum.com/excel-prog...html?p=2895807)

b)Then after I process all of the reports remove the macro from all of the workbooks so clients do not think they have a virus.

**arlu1201** · 10-09-2012, 12:36 PM

What is the name of the sheet that needs to be deleted?

The macro will not reside in all the workbooks but in one file alone (an independent macro file) which will open each of the 2000 workbooks and delete the sheet.

**Backlash** · 10-09-2012, 01:58 PM

The sheet is "Release Report"

Will it open the file then delete, save, and close?

**arlu1201** · 10-09-2012, 02:53 PM

Yeah, i will provide you the code where you can change the filepath as per your system. You can test it on a set of dummy files first.

**arlu1201** · 10-09-2012, 02:59 PM

Try this code - change the part which is highlighted below

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button