Hi,

Please help me with a VB logic on how to achieve the below.

We have 400 plus files with .xls,.xlsx,.xslm file extension in C:\EVI folder, all the excel files have multiple worksheets, I need to delete all the worksheets except the In-Progress and Completed worksheets for all the 400 plus files, and if any of the files doesn’t have the In-Progress and Completed worksheets I need to move those files to a separate folder C:\Invalid.

I tried recording the macro but the macro is working for the current excel document only, how can I achieve for all the 400 plus files.

Please suggest a logic for this.

Thanks and Regards,
Monica