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.
With this sub, I just basically open each files in a specified folder and merge them into one excel file. Everything works here.
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.
Bookmarks