VBA to delete sheet with certain name in all workbooks in a folder

Hi all,

I'm trying to build a VBA which will delete a sheet with a predetermine name from each workbook in the selected folder.

This code will be placed in a "Master Sheet" from which, when it will be started, will open one by one each worksheet in a given folder. If there is a sheet in the opened workbook with certain name (which will be filled in a list in the "Master Sheet"), the sheet will be deleted, and the workbook will be saved.

I've start preparing the code, but it does not save teh file. Can you advise where do i make the mistake i it?

Thank you.

Igor

Please Login or Register  to view this content.

спасибо nilem
i've made samll adjustment and now it works

Please Login or Register  to view this content.