Ankur thanks for the reply.
I had already tried with Exit for concept, but did n't work fine. According to your script, if I put Exit for there it will run For loop first sub excel file only and it will not go for other sub files where Header is Yes.
You have refered AOM concept, I had tried this one also, but the main problem with this is we are unable to change any data in the excel sheets if we use this concept because if we use this concept automatically excel sheets will become part of script and will become read only. Even though I had tried this also still it is giving error messages when two for loops are there.
Thanks and Regards
Narasimha
I had already tried with Exit for concept, but did n't work fine. According to your script, if I put Exit for there it will run For loop first sub excel file only and it will not go for other sub files where Header is Yes.
You have refered AOM concept, I had tried this one also, but the main problem with this is we are unable to change any data in the excel sheets if we use this concept because if we use this concept automatically excel sheets will become part of script and will become read only. Even though I had tried this also still it is giving error messages when two for loops are there.
Thanks and Regards
Narasimha
