I have bunch of excel files (approximately 1000 files ) which I want to merge them together and delete duplicate rows of them. I have the following excel vba macro to do this.

Please Login or Register  to view this content.
With this sub, I just basically open each files in a specified folder and merge them into one excel file. Everything works here.

Please Login or Register  to view this content.
This is the removing duplicate rows sub. This code works also independently. The problem is If I use this code combined with simpleXlsMerger code that I wrote. It does not work. And It gave me blank space worksheet. What are your thoughts ? Thank you so much.