Automation Error - Windows 10

Hello Experts,

I had a macro which use to consolidate 100 files at one go..
it was working fine in Windows 7 ..

Not due windows 10 update, the macro runs and consolidates 10-15 files.. or some more or some less..
but it crashes & excel closes...

after running 5-6 timess.. i got an Automation Error popup.. thats it..


its doenst work.. can you please help assist me on this..

I'm waiting for a crystal ball but you can restart from the yellow banner at the top of this page (like forum rules too) …

Hi marc, it is just a sample consolidation macro.. it works well in windows7...consolidating 100 files in one go


but when run the same tool auto quits in windows10 after consolidating 30-35 files..

I have the tool downloaded from below URL.. works great on Windows 7... but not on windows 10..


https://www.rondebruin.nl/win/addins/rdbmerge.htm