topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 12:56 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

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

arunkw

  • Participant
  • Joined in 2011
  • *
  • Posts: 2
    • View Profile
    • Donate to Member
IDEA: Delete extra Sheet2 and Sheet3 from Excel workbook
« on: October 27, 2011, 05: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
  • **
  • default avatar
  • Posts: 345
    • View Profile
    • Donate to Member
Re: IDEA: Delete extra Sheet2 and Sheet3 from Excel workbook
« Reply #1 on: October 27, 2011, 04: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, 04:09 PM by bob99, Reason: added \"This link...\" »