Loop through .xml files stored in a folder and format it using VBA

[karankk]

So I have around 100 excel files saved as .xml in my folder and I have written a VBA code which formats the layout settings of each worksheet of all the workbooks(files) in my folder. But the problem is the code does not work on the last worksheet of all the workbooks, it works perfectly fine for the rest i.e. till the last worksheet of each workbook. Here is the code:

Please Login or Register  to view this content.

Pleas/e let me know where I went wrong. Thanks

[jolivanes]

The first place where you went wrong is not adhering to the forum rules.
In your case, number 3 in the forum rules.

[karankk]

Sorry about that. I have made the change.

[Alf]

Strange as your code looks right to me. You could try

Please Login or Register  to view this content.

and you would need to dim i as an Integer and you end the loop with

Please Login or Register  to view this content.

of cource. But as I said I'm puzzled because your loop should work.

Alf