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..