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
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
Posting code? Use <pre> tags for VBA and <code> tags for inline.
Ron,
As usual a nice utility which also works with a localized version of 2007 :)
Kind regards,
Dennis
I add a code page with FSO examples also today
http://www.rondebruin.nl/fso.htm
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
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
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!
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
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
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
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
I upload version 1.3 for Excel 97-2003 also today