10 thoughts on “Merge Add-in”

1. Ron,

   As usual a nice utility which also works with a localized version of 2007 :)

   Kind regards,
   Dennis

2. I add a code page with FSO examples also today
   http://www.rondebruin.nl/fso.htm

3. Hi Mr. Walkenbach:
   Thank you for your excellent books and websites.
   I am looking for an Add-In that will allow
   1. To combine tabs from different files into one file
   2. While maintaining the individual print settings of each tab.

   In absence of such a utility / add-in,
   we have to open / cascade as many as 60 individual files,
   and consolidate them using drag and drop in a 61st file.

   If you could publish such a utility / add-in,
   it would save us countless hours from an inefficient process.

   Much appreciate your counsel.

   Regards
   RP

4. Hi RP

   Not John but Ron

   In the next RDBMerge add-in version there will be a option to merge worksheets.
   I have a code example on this page for you
   http://www.rondebruin.nl/fso.htm

5. Thanks a lot! I look up to you guys who are able to produce such utilities. I wish I had just 1% of your kwnoledge. Thanks a lot!

6. Hi Ron

   I couldn’t install your RDBMerge add-in. I downloaded and put it into the library unzipped it, then opened a worksheet went to the tools>add-in but it didn;t appear there. Could you tell me what and where am I doing wrong? I can send the screen shot but I cannot attach here. So if you also tell me how to send this shot I can send to you.to I you have

   I enjoy the Excel and your articles I must be in my ing=fancy to appreciate your work.

   Thank you and your friends for these pages

7. Hi Ron,

   I find myself forever looking at your page and using your add-ins. THANKS SO MUCH!

   I have a question that maybe you can help with.

   I am trying to open several workbooks and copy a column into a master worksheet. I would like the column to copy into the next open column and I can not get it to work.

   I have downloaded and used your RDBMerge and it is great for rows but no luck with columns.

   If you can help I would REALLY appreciate it.

   Thanks

   Rosie

8. Hi Rosie

   I will add this in the new version.
   But i have a code example on my site.

   http://www.rondebruin.nl/copy3.htm

9. Hi all

   FYI

   I upload a new version(1.3) for 2007-2010 with a option to copy next to each other
   Will update the add-in for 97-2003 also this week

   If you have suggestions or find problems let me know

10. I upload version 1.3 for Excel 97-2003 also today

---

Posting code? Use <pre> tags for VBA and <code> tags for inline.