Merge Add-in

Hi all

I have a new add-in named RDBMerge on my site to merge data from all workbooks in a folder.
http://www.rondebruin.nl/merge.htm

It is very small and easy to work with.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

8 Comments

  1. Dennis Wallentin:

    Ron,

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

    Kind regards,
    Dennis

  2. Ron de Bruin:

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

  3. RP:

    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. Ron de Bruin:

    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. Alessandro:

    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. mathsmagician:

    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. Rosie:

    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. Ron de Bruin:

    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

Leave a comment