hi Sean try this macro. select the folder which is having all the excel files.
On Fri, Oct 21, 2011 at 2:08 AM, Sean <flanagan.se...@gmail.com> wrote: > Hi and thanks for your interest in my post. > > I'm using in MSExcel 2007 and using code I've found in various forums > and published by MVPs, to perform some column copying > . Some of the code were macros, and one is an add-in. All fail, but > with different faults. > > I used a macro from Microsoft 'MergeHorizontally' which crashes Excel > when trying to open spreadsheets identified with an array: > Set mybook = Workbooks.Open(MyPath & MyFiles(FNum)) > > > I used macros developed by Ron de Bruin, Microsoft MVP - Excel > including 'CopyRange' and 'CopyRangeValues'. These halt with run-time > error 445 - Object doesn't support this action on the line: > With Application.FileSearch > > > In my troubleshooting, I founda a wonderful add-in utility that Ron de > Bruin created, 'RDBMerge'. This produces a different automation error > (Error 440) > Run-time error '-2147417848 (80010108)': > Automation error > The object invoked has disconnected from its clients. > > Object doesn't support this action (Error 445) > > > I suspected my Exccel installation, yet I have installed Office 2007 > on another computer and get the same results. > > Any suggestions would be gratefully received. > > (If it matters, I have perhaps 200 .xlsx workbooks with various names > having mostly twenty or so rows (but as many as 1500) in the first 13 > columns that I wish to copy-append into one spreadsheet. I desire > some functioning code because my VBA skills are many years out of > date.) > > Regards, > -Sean- > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
MERGE DATA MACRO.xlsm
Description: Binary data