Hi,
I'm using Ron de Bruin's Merge worksheets code (adapted for my needs) to combine two sets of workbooks. I've added in my own code as well to edit these merged sheets. The code opens a browser for the user to select a folder and then merge the workbooks in that folder.
I've inserted a module to merge and edit each set of workbooks - Combine_T & Combine_H, and then added a third module, Merge, to call these macros to run as one.
It seem to work fine as far as opening the browser window, merging and then opening another window to browse and merge the second set on Sheet2.
The problem is it only seems to do the editing for one set of merged books, and then only merge the second set. So if I run Merge, it will merge and edit Combine_T, but then only merge Combine_H.
I've tested it as well and if I run it from Sheet2, it merge and edit Combine_H, and only merge Combine_T on Sheet1.
I've attached a workbook with the code since it's too long to post.
Shout if I haven't been clear!
Bookmarks