Delete A Worksheet From All Workbooks In A Folder

**AlexRoberts** · 07-13-2011, 10:00 AM

I have been looking for a piece of code that will delete a worksheet from every workbook in a folder, but cannot find any examples.

The worksheet may not exist, so if it does not the code should move onto the next workbook in the folder, no error messages are required.

Can anybody help me.

**Mordred** · 07-13-2011, 10:16 AM

Hi AlexRoberts, try

Please Login or Register  to view this content.

**davegugg** · 07-13-2011, 10:17 AM

Here is code that will do that. It is well commented so you know what each line of code does. You need to change the folder path to your folder, and the sheet name to your sheet you are looking to delete.

Please Login or Register  to view this content.

**AlexRoberts** · 07-13-2011, 12:41 PM

Dave,

Thanks for this.

A further question, it has just occurred to me that a spreadsheet may be open, is there a way to (a) ignore spreadsheets that are open and (b) list the file name of those open spreadsheets in another spreadsheet (log of some sort).

Thank you.

**davegugg** · 07-13-2011, 12:49 PM

Please Login or Register  to view this content.

**AlexRoberts** · 07-14-2011, 02:28 AM

The time you have saved me, thank you.

**Amarjeet Singh** · 07-26-2011, 11:46 AM

Hi Davegugg , can you please amend code for me so that it unhide the particular hidden sheet and then delete it from all the workbooks in a folder?

Thanks & regards,

AG

**davegugg** · 07-26-2011, 02:01 PM

If you have an issue Amarjeet, please read the forum rules (specifically # 2) and then start a new thread. You can post a link to this thread if you feel it contains relevant information.