how to marge multiple workbook into one sheet (not working)

hello everyone,
im already using below code for marge multiple excel workbooks sheet1 into a new workbook at Microsoft office 2010-32bit

Please Login or Register  to view this content.

now my Microsoft office has been changed to office 2016 and 64 bit, after that, this code is not working, what should i not now to solve this,

thanks in advance