DonationCoder.com Software > Post New Requests Here

IDEA: Delete extra Sheet2 and Sheet3 from Excel workbook

(1/1)

arunkw:
I have lot of old excel sheet which has sheet2 & sheet3 as blank/empty/unused.
I am searching for code which could delete these sheets safely once they are verified that they don't have any data. Being non-programmer I am not able to write code.

I want to scan all the folders on my drive, pick each excel file and delete sheet2 and sheet3 after verification.

bob99:
I just found this set of Excel utilities the other day.  Haven't had a chance to try them out yet but there is one that deletes blank worksheets.  Whether it's by file or folder not sure.

This link takes you to the Sheets » Remove all empty worksheets description page.
ASAPUtilities for Excel

They have a free version for home/students/charity and a business version for $49 US.
Either way there is a trial you could give a try.

Navigation

[0] Message Index