Automation error on looper file

Hello,

I have the attached looper file which I have probably been using for over 10 years now. Lately it has been randomly throwing automation errors where it breaks down after about the 5th loop. If I F8 through it manually it will run through all of the loops until it is complete. But running it in auto I get the automation error. Any idea what may be causing this? It is frustrating because sometimes we need it to loop through over 100 template files to stack data into one file for analysis. Any help would be appreciated. We are running it currently on 64 bit 2016 excel.

Dim J as Long still threw the automation error but now on the 9th loop and not the 5th.

I think I may have figured out the issue. The file path names are very very long. Is there limitations on the file path length? Or the file name length? If you look at the attachment on the File List tab you will see the paths and some of them are gigantic. I ran them through code I have to rename files and moved them to my C drive to get a shorter path and it looped through the 130 files without the automation error. I am assuming that is the issue?

Who knows, maybe yes maybe no ?
It should be checked carefully.

https://msdn.microsoft.com/en-us/library/aa365247.aspx
https://msdn.microsoft.com/en-us/lib...5).aspx#limits