How satisfied are you with this reply? Dear Ron Thanks for prompt reply, i will be waiting for your new version. Notify me of followup comments via e-mail. Thanks so much for this — I was about to write a macro to do this myself, but thankfully I found your far more feature-laden add-in. For Each sh In mybook.
|Date Added:||14 February 2008|
|File Size:||13.93 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Ron de Bruin http: Hi Ron, you have done a great job….
Before we press on the Merge button we have a few rdmerge here that you can change. Perhaps your add-in could handle this option.
See example 4 on this page http: Yes, I am sure it exists…Actually code is working for sheets with 5 coloumns but when you have 10 coluomns with gives that error. Not tested but I will soon My main machine is also a Mac now so I am trying all Windows code to see if I can get it to work in I start this problem page http: Ashish Mathur Replied on January 10, Sign up using Email and Password.
RDBMerge, Excel Merge Add-in for Excel for Windows
The environment I work is deluged with processes where the merging of multiple workbooks are a weekly occurance. You can use it for example to filter the Combine sheet rdbmeege the data from a certain file.
Thanks Ron, I solved it by first removing the filter, merging the sheets and applying the filter again. Hello Ron, I want to call your addin in one of my macro. Actually i want to pick specific error strings from a log file and want the data in excel file for further working.
Subscribe to RSS
Hi adprim For txt files see http: This is not a easy macro. C1″ End With If Err.
This is the command line output:. All the data is missing. You are a genious in Excel.
Best way to consolidate multiple sheets from multiple workbooks
Its an awesome tool and Thank You for sharing. Click on the Merge button: Thanks for marking this as the answer. Hi Ron, Great tool. Rdhmerge have another question, how can i modify the range of the copy and pasting of the workbooks being merged?
This thread is locked. Thanks so much for this rrbmerge I was about to write a macro to do this myself, but thankfully I found your far more feature-laden add-in. You have the option to merge a fixed range can be more than one area.
Norman David Rdbmdrge Replied on January 10, Worksheets If LCase sh. Hi Duke Send me a private mail I will send you a example workbook if I have your address.