Deleting Sheet 2 and Sheet 3 from multiple excel files

[blue virus]

Hi All ,

Please let me know if there is a function/formula/macro to delete Sheet 2 and Sheet 3 from multiple excel files .

Thanks in Advance!!!!!!!!

[Logit]

.
Paste this macro into a Routine Module:

Please Login or Register  to view this content.

The code provides access to the FileSystemObject so selecting the Folder is easier. It identifies ALL "xl" files in the folder, then deletes sheets 2 & 3 in each of those files.

This is just one of most likely numerous ways to accomplish your goal.