Although vastly off topic, Excel 2010 is Excel 14. MS skipped one number 13, probably because of all the beliefs associated with that number :D
Regards, Sam Mathai Chacko (GL) On Fri, Oct 21, 2011 at 6:26 PM, dguillett1 <dguille...@gmail.com> wrote: > May be best to post your code and even your file. > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -----Original Message----- From: Sean > Sent: Thursday, October 20, 2011 3:38 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes > (or different approach) > > > 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 <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> > 4. Learn VBA Macros at > http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com> > 5. Excel Tips and Tricks at > http://exceldailytip.blogspot.**com<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<http://www.facebook.com/discussexcel> > -- > ------------------------------**------------------------------** > ---------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/** > exceldailytip <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> > 4. Learn VBA Macros at > http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com> > 5. Excel Tips and Tricks at > http://exceldailytip.blogspot.**com<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<http://www.facebook.com/discussexcel> > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- 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
