Delete all worksheets except the first one

**Nithya1987** · 11-04-2011, 11:24 AM

Hi ,

I have some xls files in C:\Prod_Dump folder, these xls have multiple worksheets, some xls files have 4 worksheets and some has 6 worksheets. I need to delete all worksheets except the first worksheet in all xls. Please give me some hint to do this.

Thank you,
Nithya

**Mordred** · 11-04-2011, 11:28 AM

Hi Nithya1987, try

Please Login or Register  to view this content.

**tigeravatar** · 11-04-2011, 11:37 AM

Nithya1987,

Modification to Mordred's code to include all workbooks in the C:\Prod_Dump folder:

Please Login or Register  to view this content.

**Mordred** · 11-05-2011, 03:02 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save