DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: IDEA: Delete extra Sheet2 and Sheet3 from Excel workbook  (Read 4,644 times)

arunkw

  • Participant
  • Joined in 2011
  • *
  • Posts: 2
IDEA: Delete extra Sheet2 and Sheet3 from Excel workbook
« on: October 27, 2011, 10:40 AM »
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

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 345
Re: IDEA: Delete extra Sheet2 and Sheet3 from Excel workbook
« Reply #1 on: October 27, 2011, 09:05 PM »
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.
« Last Edit: October 27, 2011, 09:09 PM by bob99 »

Original address: https://www.donationcoder.com/forum/index.php?topic=28484.0