When looping through Workbooks calling Macro - Run-time error '9': Subscript out of range

Hello folks,

The below code loops through several .xlsm workbooks, calling the Startx macro for each workbook.
Most times it works perfectly, but, eventually, I get the following error:

Run-time error '9':
Subscript out of range

Then on this same message box there are the buttons: End, Debug and Help

When I click on Debug, it highlights this part of below code:

Please Login or Register  to view this content.

Then I simply need to click on Play button, and it continues the macro until it completes successfully.

In order to try to fix this issue I tried to minimize the screen of AllWorkbooks macro, but it did not work.

Does anybody has any idea on what I need to do to solve this?

Please Login or Register  to view this content.

When the code stops(gives the error mentioned above), I checked MyFile value and it contains the correct Workbook Name... By somehow it is stopping on that part.

I found where the error was. On mine last module of Startx module, I call a module that saves the worksheet data in TXT format, which opens a new workbook to do the work(to save the TXT file), and this was messing up the loop through Workbooks on module AllWorkbooks. Thanks!